C czf8891 Unregistered / Unconfirmed GUEST, unregistred user! 2007-08-10 #1 我想把Table1中的字段bb的值修改成与 Table2中的字段TT一样的值，当Table1.id=Table2.id,怎么写语句，小弟非常感谢！！
S s00000000001 Unregistered / Unconfirmed GUEST, unregistred user! 2007-08-10 #2 UPDATE Table1 SET bb = Table2.TT FROM Table1, Table2 WHERE Table1.id = Table2.id
C czf8891 Unregistered / Unconfirmed GUEST, unregistred user! 2007-08-10 #3 首先感谢你为我提供答案！！我也是这样写的，怎么不行啊，提示：ORA-00933:SQL命令未正确结束。 我用的是Oracle,在PL/SQL里写的
S suyi3026 Unregistered / Unconfirmed GUEST, unregistred user! 2007-08-10 #4 oracle肯定不行拉 我 沒搞過 oracle
P power255 Unregistered / Unconfirmed GUEST, unregistred user! 2007-08-10 #5 UPDATE Table1 SET bb = (select Table2.TT from Table2 WHERE Table1.id = Table2.id)
M maikee1978 Unregistered / Unconfirmed GUEST, unregistred user! 2007-08-10 #6 UPDATE Table1 SET bb = Table2.TT FROM Table1 join Table2 on Table1.id = Table2.id
贝 贝尔 Unregistered / Unconfirmed GUEST, unregistred user! 2007-08-13 #7 update table1 set bb=table2.tt from table1,table2 where table1.id=table2.id
S spirit_day Unregistered / Unconfirmed GUEST, unregistred user! 2007-08-22 #9 oracle里这样写： update table1 a set a.bb=(select b.tt from table2 b where a.id=b.id)
