以下のように書くことで、
同じテーブルを複数回JOINすることが可能です。
SELECT * FROM table
INNER JOIN join_table AS join1
ON table.id = join1.id
INNER JOIN join_table AS join2
ON table.another_id = join2.another_id
JOINするテーブルをASを用いて、それぞれユニークなものにしてやればいいわけですね。
More than 5 years have passed since last update.
Register as a new user and use Qiita more conveniently
- You get articles that match your needs
- You can efficiently read back useful information
- You can use dark theme