update IE_Prescription
set IE_Prescription.GenericName = IE_Master_Medicine.GenericName
from IE_Prescription
inner join IE_Master_Medicine on
IE_Prescription.GenericCode = IE_Master_Medicine.Code
and IE_Prescription.GenericName <> IE_Master_Medicine.GenericName
set IE_Prescription.GenericName = IE_Master_Medicine.GenericName
from IE_Prescription
inner join IE_Master_Medicine on
IE_Prescription.GenericCode = IE_Master_Medicine.Code
and IE_Prescription.GenericName <> IE_Master_Medicine.GenericName
No comments:
Post a Comment