求一条SQL语句,100分

[microgiant]

各位,小弟对SQL不熟,所以请教一条语句

比如,我有两张表A,B

把B表里面的数据作为条件,select 出A表的结果

然后我想把这些结果从A表里面删除了

请问,我该如何写这条SQL语句?

[發糞塗牆]

select * from a where exists (select 1 from b where a.条件=b.条件)删除的话 delete from a where exists (select 1 from b where a.条件=b.条件)

[發糞塗牆]

最好文本形式贴出测试数据和表结构，还有期待结果

[microgiant]

谢谢楼上,但是说报错啊,语句如下: delete from A where exists(select * from A where A.字段 not in (SELECT cast(cast(字段 as varchar(10)) AS int) FROM B)) ) 说是select附近有语法错误

[發糞塗牆]

delete from A where A.字段 not in (SELECT cast(cast(字段 as varchar(10)) AS int) FROM B))

[發糞塗牆]

你写错了而已，另外建议先做表的备份再删，用select * into A_bak from A就可以把A表备份到A_bak表了

[microgiant]

哦了,结贴,谢谢楼上

[ai_li7758521]

delete from A 
where A.字段 not in (SELECT cast(cast(字段 as varchar(10)) AS int) FROM B))