PHP MYSQL 反选

Question

$line = @mysql_query("SELECT * FROM clips, userclips 
WHERE userclips.userid='$id' AND 
userclips.clipid=clips.id ORDER BY clips.title");

返回与特定用户关联的所有剪辑。但是，我很难尝试编写一个完全相反的查询；选择与该用户无关的所有剪辑。

我试过这个:

$line = @mysql_query("SELECT DISTINCT * FROM clips, userclips 
WHERE userclips.userid!='$id' AND userclips.clipid=clips.id ORDER BY clips.title");

它会返回与该用户无关的剪辑，但它会遗漏与任何用户无关的剪辑。

如果可以请帮忙:)

Answer 1

 $line = @mysql_query("SELECT DISTINCT * FROM clips WHERE clips.id 
 NOT IN (SELECT clipid FROM userclips WHERE userid='$id') ORDER BY clips.title");