SQL更新语句问题

[cheny]

有表table1 字段ID,a,b,c,d
表table2 字段ID,c,d,e,f
要根据ID相等把table2的c,d数据更新到table1中应该怎么写呀
sqlserver很简单,oracle不熟悉,请教一下

[tcmis]

update table1 a set c = (select c from table2 where id = a.id),d = (select d from table2 where id = a.id);

[bluemeteor]

总要有点条件吧...
update set ta1.c=ta2.c where...

[yuxuan]

update table1 a set c,d = (select c,d from table2 where id = a.id)

[beckhambobo]

update table1 a set (c,d) = (select c,d from table2 where id = a.id)