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