JZTXT

update left join 在MySQL和SQL Server使用方式区别

发布时间 2023-10-16 09:41:30作者: Java从入门到入门

(1)MySQL使用

UPDATE hayl_service_info t1
left join hayl_Old_info t2 on t1.CERT_NO =t2.CERT_NO
set t1.AAP0112 = t2.ADDRESS
where t1.AAP0112=''

(2)SQL Servers使用

UPDATE hayl_service_info 
set AAP0112 = t2.ADDRESS 
from hayl_service_info t1
left join hayl_Old_info t2 on t1.CERT_NO =t2.CERT_NO
where t1.AAP0112=''