Как при связке 3 таблиц SQL выполнить WHERE?

210

04 июля 2018, 00:10

Есть такой запрос:

    SELECT s_products.name, s_categories.id, s_products_categories.product_id, s_products_categories.category_id
FROM s_products 
LEFT JOIN s_products_categories ON s_products.id = s_products_categories.product_id
LEFT JOIN s_categories ON s_categories.id = s_products_categories.category_id
ORDER BY s_categories.id

Как выполнить в этой объединённой таблице WHERE s_categories.id = 7

    name            | id | product_id | category_id
    Футболка Красная| 6  | 1213       | 6
    Футболка Синяя  | 7  | 1345       | 7
    Куртка          | 7  | 1270       | 7

Answer 1

Так, что ли?

SELECT s_products.name, s_categories.id, s_products_categories.product_id, s_products_categories.category_id
FROM s_products 
LEFT JOIN s_products_categories ON s_products.id = s_products_categories.product_id
LEFT JOIN s_categories ON s_categories.id = s_products_categories.category_id AND s_categories.id = 7 
ORDER BY s_categories.id

Или так?

SELECT s_products.name, s_categories.id, s_products_categories.product_id, s_products_categories.category_id
FROM s_products 
LEFT JOIN s_products_categories ON s_products.id = s_products_categories.product_id
LEFT JOIN s_categories ON s_categories.id = s_products_categories.category_id 
WHERE s_categories.id = 7 
ORDER BY s_categories.id

Плохо понятно, что же нужно...