update TousseInstance set idCardInstanceBarcode=(select barcode from barcodeDevice where id=TousseInstance.idCardInstanceID) where idCardInstanceID is not null and idCardInstanceBarcode is null;