我有2个表,一张用于文章,另一张用于某些属性我有一些具有价值的属性的产品。我还有其他属性。我要创建的查询是获取所有没有属性7的产品。
您可以检查MySQL表。
http://sqlfiddle.com/#!!2/f75eec/1
select a.ArticleID,a.ArticleTitle,aa.ArticleID,aa.AttrID,aa.StringValue
from cms_articles a
inner join cms_attr_art aa on aa.ArticleID = a.ArticleID
where a.ArticleID NOT IN (select ArticleID from cms_attr_art where AttrID = 7);
您可以使用此查询
SELECT a.ArticleId, b.attrId
FROM cms_articles a
INNER JOIN cms_attr_art b
ON a.articleId = b.articleId
WHERE NOT EXISTS (SELECT 1 FROM cms_attr_art c WHERE c.articleid = a.articleid AND c.attrId = 7)