sql server 多表关联更新 update


update a
set a.KSMC = b.name
from JC_KSXXB a
inner join chisdb_ymyy..zd_unit_code b on a.KSDM = b.code

posted @ 2018-10-06 17:27  瓜蛋  阅读(40304)  评论(0)  编辑  收藏  举报