30分求助简单问题,解决马上给分.

[zelef]

表A数据
no mm pp
a001 10 1
a002 10 2
a003 10 3
...............
表B数据
no ww zdate
a001 1.1 2004/05/02
a002 2.2 2004/02/02
a003 3.3 2004/04/06
............
怎样根据两个表的no相同,由表A中pp字段为3的no,删除表B中相同的no那一列数据. 请各位老大帮忙,回答正确立即给分!

[yesterday2000]

delete b from a b where a.no=b.no and a.pp=3

[yesterday2000]

错了
delete b from 表a a, 表b b where a.no=b.no and a.pp=3

[yesterday2000]

TNN的
改了后面没改前面
delete 表b from 表a a, 表b b where a.no=b.no and a.pp=3

[sankis]

Delete From 表B B, 表A A Where S.NO=B.NO And A.pp=3

[sankis]

晕错了。
Delete From 表B B, 表A A Where A.NO=B.NO And A.pp=3

[ghy412]

delete from b where no in (select * from a where pp=3)

[yjr332533]

delete from b where no in (select * from a where pp=3)