我太懂这种踩坑的感觉了——你用SELECT验证完数据完全正确，一换成DELETE就出问题，核心原因是数据库不知道你要删除哪个表的记录。你的查询关联了三个表，直接写DELETE的话，数据库没法自动判断目标是tblPlaylist_Tracks、tblPlaylist还是tblTrack。

正确的写法（分数据库场景） #

首先明确：看起来你要删除的是中间关联表tblPlaylist_Tracks里的匹配行（毕竟主表的播放列表和曲目一般不能随便删），那我们需要在DELETE语句里明确指定目标表：

MySQL/MariaDB 写法

DELETE tblPlaylist_Tracks
FROM tblPlaylist_Tracks
INNER JOIN tblPlaylist ON tblPlaylist_Tracks.PlaylistID = tblPlaylist.PlaylistID
INNER JOIN tblTrack ON tblPlaylist_Tracks.TrackID = tblTrack.TrackID
WHERE Playlist_Name = "x" AND Track_Name = "y";

SQL Server 写法

DELETE FROM tblPlaylist_Tracks
FROM tblPlaylist_Tracks
INNER JOIN tblPlaylist ON tblPlaylist_Tracks.PlaylistID = tblPlaylist.PlaylistID
INNER JOIN tblTrack ON tblPlaylist_Tracks.TrackID = tblTrack.TrackID
WHERE Playlist_Name = "x" AND Track_Name = "y";

Oracle 写法

Oracle的语法略有不同，需要用子查询定位要删的行：

DELETE FROM tblPlaylist_Tracks
WHERE (PlaylistID, TrackID) IN (
    SELECT pt.PlaylistID, pt.TrackID
    FROM tblPlaylist_Tracks pt
    INNER JOIN tblPlaylist p ON pt.PlaylistID = p.PlaylistID
    INNER JOIN tblTrack t ON pt.TrackID = t.TrackID
    WHERE p.Playlist_Name = 'x' AND t.Track_Name = 'y'
);

关键提醒 #

• 永远不要在多表JOIN的DELETE里省略目标表，这会导致数据库抛出歧义错误
• 执行DELETE前，一定要再跑一遍对应的SELECT确认筛选的行是你要删的（毕竟删数据不可逆）
• 如果真的需要同时删除多个表的行，不同数据库有各自的多表DELETE语法，但这种关联场景下，优先删中间表的记录更安全

内容的提问来源于stack exchange，提问作者Steven Smith