How to link 3 tables?

Question

MySQL

Hello.
There are 3 tables:
posts - posts are stored (id)
categories - created categories (id)
item_category - category connection with a post (post_id, category_id
) categories?

Answer 1

SELECT * FROM categories
INNER JOIN item_category ON item_category.category_id = category.id
INNER JOIN posts ON posts.id = item_category.post_id