关于 sql 查询和删除....请教！

[cnmllll]

select A.ID from A left join B on A.ID=B.ID where B.ID is null

1.我用以上语句搜出了和 B 表未关联的 A.ID

2.请问我该如何写 sql 才能直接删除这些 A.ID ，既一条语句删除查出来未关联的 ID

[cnmllll]

delete from A.ID where A.ID not not in (select A.ID from A left join B on A.ID=B.ID where B.ID is null)
这样可以么

[cnmllll]

delete from A where A.ID not not in (select A.ID from A left join B on A.ID=B.ID where B.ID is null)
这个

[jintianfengda]

DELETE
a
FROM
a
LEFT JOIN
b
ON
a.ID = b.ID
WHERE
b.id is null

[cnmllll]

delete from A where A.ID in (select A.ID from A left join B on A.ID=B.ID where B.ID is null) 这个终极版

[akira]

这个 sql 和 select id from A where id is null 有啥区别

[lrh3321]

@akira 表 A 中的行在表 B 中不一定有对应的行，他要删的就是这些无用的行。

[akira]

@lrh3321 嗯呐，审题不仔细 >"<

[iwiki]

delete from a where not exists (select 1 from b where a.id=b.id)