mysql中左连接右表补0_为什么这个左连接不显示左边的表中与右表不匹配的所有数据？ (MySQL的)...

我有以下查询应该是从Articles_New中选择所有文章，它们是A)不在ArticlesInCategories_New或B)中，但没有CategoryID = 7,8,9,10或11。

通过删除Category！=行，我确定问题是(至少)Articles_New不是从Articles_New中选择不在ArticlesInCategories_New中的所有内容。我还是不太了解GroupBy，但是我基于其他问题，我尝试过GroupBy Articles_New.ArticleID，但这并没有改变任何事情。

SELECT

DISTINCT Articles_New.ArticleID,

DATE_FORMAT(Articles_New.PublicationDate, '%c/%e/%Y') AS ReleaseDate,

Articles_New.Title,

Articles_New.Type,

Articles_New.URL

FROM

Articles_New

LEFT JOIN ArticlesInCategories_New

ON ArticlesInCategories_New.ArticleID = Articles_New.ArticleID

WHERE

PublicationDate >= DATE_SUB(CURDATE(), INTERVAL 2 MONTH) AND

PublicationDate <= CURDATE() AND

Articles_New.Public = '1'

AND ArticlesInCategories_New.CategoryID != '7'

AND ArticlesInCategories_New.CategoryID != '8'

AND ArticlesInCategories_New.CategoryID != '9'

AND ArticlesInCategories_New.CategoryID != '10'

AND ArticlesInCategories_New.CategoryID != '11'

ORDER BY

Articles_New.PublicationDate DESC,

Articles_New.ArticleID DESC