在一个表中删除在另外一个表中已存在的相同记录，该怎样写T-SQL语句呢？

[arclala]

两个表结构一样，如下
表A
ProjectID ProjectName
#113 kkkk
#114 jjj
#115 dddd
.........

表B
ProjecID ProjectName
#113 kkkk
#114 jjj
.........


我想实现这样的功能，即如果#113,#114已存在与表B中，那么表A中的相同记录需要删除？该怎样写T-SQL语句呢？谢谢！

[Forwardrun]

delete from a where projectid in (select projectid from b)

[饮水需思源]

delete from a where projectid in (select projectid from b)

[zheninchangjiang]

delete from 表a a join 表b b on a.projectid=b.projectid

[leeboyan]

delete from 表A from 表A a join 表B b on a.ProjectID=b.ProjectID