mysql - 获取所有term等于Mysql查询的条目

Question

我有 2 张 table

新闻

+---------+---------------+---------------+--------------+--------+
| news_id |     title     |     short     |     body     | etc... |
+---------+---------------+---------------+--------------+--------+
|  881971 | Article Title | Article short | Article Body |        |
|  881972 | Article Title | Article short | Article Body |        |
|  881973 | Article Title | Article short | Article Body |        |
+---------+---------------+---------------+--------------+--------+

术语

+-----+--------------+
| tid | news_term_id |
+-----+--------------+
|  14 |       881971 |
|   2 |       881972 |
|   2 |       881973 |
+-----+--------------+

我需要从表News中选择所有内容，其中Term中的tid等于2(例如)尝试这样:

SELECT *
FROM news, term
WHERE news.news_id = term.tid 
GROUP BY term.tid

但这不是我需要的。就像带有类别的博客文章一样，需要选择类别 id 2 的所有文章

Answer 1

这是您要找的吗？

select n.*, t.*
from news n
inner join term t 
    on n.news_id = t.news_term_id 
    and t.tid = 2