update aa set aa.a1=bb.a1 aa.a2=bb.b2 from bb where aa.a3=bb.b5 and aa.a4=bb.b6
update aa set aa.a7=cc.c1 aa.a8=cc.c2 from cc where aa.a5=cc.c5 and aa.a6=cc.c6
这两个语句能在同意表单中连续使用吗?能否合并或者简化,请高手赐教!
update aa set a1=(select a1 from bb where aa.a3=bb.b5 and aa.a4=bb.b6)
update aa set a7=(select c1 from cc where aa.a5=cc.c5 and aa.a6=cc.c6)
这两单独可以使用,但update aa set a1=(select a1 from bb where aa.a3=bb.b5 and aa.a4=bb.b6) a7=(select c1 from cc where aa.a5=cc.c5 and aa.a6=cc.c6)
就不行