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两个表,我只是举个例子!
...全文
719打赏收藏
oacle怎么更新表内一行数据?
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两个表,我只是举个例子!