UPDATE    Patient
SET    Patient_Area = Area.Area_Desc --etc
FROM    Patient
    JOIN
    Area ON Patient.Patient_Area=Area.Area_Id

Comments (0)