Добавил:
itan_hunt
Опубликованный материал нарушает ваши авторские права? Сообщите нам.
Вуз:
Предмет:
Файл:q5
.sql (SELECT
good.name AS good_name,
category.name AS category_name
FROM category_has_good
LEFT JOIN good
ON category_has_good.good_id = good.id
RIGHT JOIN category
ON category_has_good.category_id = category.id)
UNION
(SELECT
good.name AS good_name,
category.name AS category_name
FROM category_has_good
RIGHT JOIN good
ON category_has_good.good_id = good.id
LEFT JOIN category
ON category_has_good.category_id = category.id)
LIMIT 10;
good.name AS good_name,
category.name AS category_name
FROM category_has_good
LEFT JOIN good
ON category_has_good.good_id = good.id
RIGHT JOIN category
ON category_has_good.category_id = category.id)
UNION
(SELECT
good.name AS good_name,
category.name AS category_name
FROM category_has_good
RIGHT JOIN good
ON category_has_good.good_id = good.id
LEFT JOIN category
ON category_has_good.category_id = category.id)
LIMIT 10;
Соседние файлы в предмете Основы технологии хранения данных