Question

delete from A where ID in (1,2,3) and not in(select ID from B) 可以在SQL里面使用，而不能在Mysql使用

ID是A表和B表相关联的字段，

Answer 1

delete from A where ID in (1,2,3) and ID not in(select ID from B)

或
delete from A
where not exists (select ID from B where ID=A.ID) and ID in (1,2,3)

追问

不行，执行的时候，不报错，就不删除数据？单是在SQl Server里面执行就OK？