这种写法轻松, 而且不易出错。 UPDATE patient SET ForeignName = ForeignName_New FROM Patient_YNG WHERE patient.PatientID = patient_yng.PatientID AND patient.ClinicID = 1483