mysql查询相关文章

Question

我有以下表格:

• 文章 (idArticle)
• 文章标签 (idArticle, idTag)
• 标签 (idTag)

我想获取所有与文章“5”具有相同标签的文章，我正在尝试:

SELECT DISTINCT Article.*
FROM Article
INNER JOIN ArticleTag ON Article.idArticle = ArticleTag.idArticle 
       AND ArticleTag.idArticle = "5"
WHERE 1 = 1
ORDER BY title
LIMIT 40

但它显示了所有文章，而不是相关文章。

Answer 1

尝试

select a.* from Article a
inner join ArticleTag at
  on at.idArticle = a.idArticle
where at.idTag in (select idTag from ArticleTag where idArticle =5)

或

select a.* from Article a
inner join ArticleTag at on at.idArticle= a.idArticle
inner join ArticleTag at2 on at2.idTag = a.idTag and at2.IdArticle! = at.idArticle
where at2.idArticle = 5