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

(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=''