mysql - 选择其他表不包含同类记录的查询

Question

我需要有关此查询的帮助...

SELECT FIRST_NAME, LAST_NAME, test.EMAIL 
      FROM test
INNER JOIN suppression ON suppression.EMAIL = test.EMAIL
AND NOT EXISTS (select * from suppression)

我想要表“test”中的所有记录，其中表“suppression”不包含类似的记录。

Answer 1

使用LEFT JOIN

SELECT  a.*
FROM    test a
        LEFT JOIN suppression 
            ON suppression.EMAIL = a.EMAIL
WHERE   suppression.EMAIL IS NULL

要全面了解联接，请访问以下链接:

• Visual Representation of SQL Joins