日期:2014-05-17 浏览次数:20468 次
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')