本文介绍了一种使用SQL从两个关联表中删除记录的方法。通过连接Table_A和Table_B，并基于ID匹配条件，实现精确删除Table_A中指定记录的功能。
delete from Table_A
from Table_A, Table_B
where Table_A.ID = Table_B.ID
即
delete Table_A
from Table_A, Table_B
where Table_A.ID = Table_B.ID
即
delete from Table_A
where exists(
select Table_A.ID
from Table_B
where Table_A.ID = Table_B.ID)
from Table_A, Table_B
where Table_A.ID = Table_B.ID
即
delete Table_A
from Table_A, Table_B
where Table_A.ID = Table_B.ID
即
delete from Table_A
where exists(
select Table_A.ID
from Table_B
where Table_A.ID = Table_B.ID)
扫一扫
1万+
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
