22,210
社区成员
发帖
与我相关
我的任务
分享
delete from dbo.A A where A.pid in (select id from dbo.B B where B.name in ('AAA','BBB'))
delete from dbo.A where pid in (select id from dbo.B B where B.name in ('AAA','BBB'))
delete from dbo.A inner join dbo.B on dbo.A.pid=dbo.B.id where dbo.B.name in ('AAA','BBB')