链接update

来源:互联网 发布:广州淘宝实景摄影棚 编辑:程序博客网 时间:2024/06/05 04:59
update tabA t
set t.customerdesc=(select t3.customerdesc from tabB t3 where t.customerid=t3.customerid),
t.legalperson=(select t3.legalperson from tabB t3 where t.customerid=t3.customerid),
t.permitno=(select t3.permitno from tabB t3 where t.customerid=t3.customerid)
原创粉丝点击