php - 如何从具有其他表条件的表中进行选择

Question

我有这个 mysql 设置:

*words* table
+----+-----------+
| id |   word    |
+----+-----------+
| 1  |  curse1   |
| 2  |  curse2   |
| 3  | niceWord1 |

*Category* table
+----+-----------+
| id |    name   |
+----+-----------+
| 1  | niceWords |
| 2  | badWords  |

*link* table
+----+--------+-------+
| id | wordID | catID |
+----+-----------+----+
| 1  |    1   |   2   |
| 2  |    2   |   2   |
| 3  |    3   |   1   |

我想做一个 MySQL SELECT，我说我想使用链接表选择所有坏词
所以我会得到类似这样的输出:

+----------+------------+---------------+
| words.id | words.word | Category.name |
+----------+------------+---------------+
|    1     |  curse1    |   badWords    |
|    2     |  curse2    |   badWords    |

我想我需要使用某种 JOIN，我不太擅长 SQL。

Pastebin 具有相同的内容:http://pastebin.com/ML684RRA

Answer 1

select words.id, words.word, Category.name
from words
join link on link.wordid = words.id
join category on category.id = link.catid
where category.name = 'badWords'