日期:2014-05-18 浏览次数:20466 次
update a set CC=b.CC from 表1 a join 表2 b on (a.AA=b.AA and a.BB=b.BB)
------解决方案--------------------
update tb1 set cc = tb2.cc from tb1 , tb2 where tb1.aa = tb2.aa and tb1.bb = tb2.bb
------解决方案--------------------
update a set a.cc=b.cc from 表1 a left join 表2 b on a.aa=b.aa and a.bb=b.bb
where a.cc is null