tgoop.com/sqlquestions/758
Create:
Last Update:
Last Update:
Решение к #Задача15:
SELECT e.last_name,
e.first_name,
e.store_id as store_id_employee,
r.store_id as store_id_rank,
r.rank_id,
r.name as rank_name
FROM employee e
JOIN ranks r
ON r.store_id = e.store_id
OR (r.rank_id = e.rank_id AND r.store_id != e.store_id)
ORDER BY e.last_name, e.first_name, r.store_id, r.rank_id
#задача
BY SQL задачи
Share with your friend now:
tgoop.com/sqlquestions/758