update A a set a.a= b.b from B b on a = '007'
update A a set a.a = b.b from B b where a = '007',
都不对,为什么呢? 这下这么写啊!、
update A a set a.a = b.b
a.a1 = **
a.a2 = ‘0303’
a.a3 = **
a.a4 = sysdate
.......
from B b where a = '007',
很多的,也不可能只是A.B两个表,我只是举个例子!
update A a set a.a = b.b from B b where a = '007',
都不对,为什么呢? 这下这么写啊!、
update A a set a.a = b.b
a.a1 = **
a.a2 = ‘0303’
a.a3 = **
a.a4 = sysdate
.......
from B b where a = '007',
很多的,也不可能只是A.B两个表,我只是举个例子!
update A a set a =(select b.b from B b where a = '007')
where a = '007'
update A a set a.a = b.b
a.a1 = **
a.a2 = ‘0303’
a.a3 = **
a.a4 = sysdate
....... 这样的。无法实现吗?