-
-
-
- UPDATE patient
- SET ForeignName = (
- SELECT ForeignName_New
- FROM Patient_YNG
- WHERE patient.PatientID = patient_yng.PatientID
- )
- WHERE patient.ClinicID = 1483
- AND patient.PatientID IN (SELECT patientid
- FROM Patient_YNG)
-
-
-
- UPDATE patient
- SET ForeignName = ForeignName_New
- FROM Patient_YNG
- WHERE patient.PatientID = patient_yng.PatientID
- AND patient.ClinicID = 1483
select * from spkfk b ,hwsp a where hw='HWI00000001' and hwshl>0 and a.spid=b.spid and tongym like'%2'
我已经把条件选择出来了,但是想把,A表里的hwshl更新成0,条件就是where后边的 update hwsp set hwshl = 0 from hwsp , spkfk b where hw='HWI00000001' and hwshl>0 and hwsp.spid=b.spid and tongym like'%2'
|