我必须从slaveTable中删除与master表没有更多关系的行(死关系,从master表中删除)。
我提出了一个声明:
DELETE
FROM slaveTable AS s
LEFT JOIN
masterTable AS m
ON ( s.key1 = m.key1
AND s.key2 = m.key2 )
WHERE m.key1 IS NULL
SQL DELETE与用于WHERE条件的JOIN另一个表将此方式显示为解决方案。。。但对我不起作用。由于我缺乏声誉,我无法回答。
指定要删除行的表。
DELETE s -- << HERE: s (alias of slaveTable )
FROM slaveTable AS s
LEFT JOIN
masterTable AS m
ON ( s.key1 = m.key1
AND s.key2 = m.key2 )
WHERE m.key1 IS NULL