sql的UPDATE语句高分求救?

[xjchenming]

有两张表
TABLE1
字段 ID FLAG ...
001 Y
002 N
003 N
...
TABLE2
字段 ID ...
003
...
我想写一条
UPDATE语句,要求更新TABLE1的FLAG字段为Y, 条件是TABLE1表中的ID号在TABLE2表中的ID号出现过.

[hahahahaanni]

update table1 set flag='y' where id in (select id from table2)

[windindance]

update table1
set flag = 'y'
where exists(select * from table2 where id = tabel1.id)

[xjchenming]

有没有人知道?

[rwq_]

update table1 set flag='y' from table2 where table1.id=table2.id;

==========================
20分也算高分？^-^

[xjchenming]

只有hahahahaanni(寒岩翠柳)对,其他都有语法错误!!!

[wylyf]

update table1 set flag='y' where id in
(select distinct id from table2)