Sunday, 3 August 2014

Swaping/Updating one column data into anothe column data with JOIN SQL SERVER Query

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

No comments:

Post a Comment