Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT pr.name, ca.name
- FROM (product pr LEFT JOIN pair pa ON pr.ID = pa.product_ID) LEFT JOIN category ca ON pa.category_ID = ca.ID;
- --product - таблица продуктов,
- --category - таблица категорий,
- --pair - таблица пар значений "ID продукта - ID категории".
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement