SELECT s.last_name AS employee_last_name,
ss.reports_to AS manager_last_name
FROM staff AS s
LEFT JOIN staff AS ss ON s.employee_id=ss.reports_to
GROUP BY 1, 2
SELECT DISTINCT s.last_name AS employee_last_name,
ss.reports_to AS manager_last_name
FROM staff AS s
LEFT JOIN staff AS ss ON s.employee_id=ss.reports_to
Re: task 4
From Ivory Tortoise, 1 Year ago, written in Plain Text, viewed 333 times.
This paste is a reply to task 4 from Ilya
- go back
URL http://codebin.org/view/ff93bc71/diff
Embed
Viewing differences between task 4 and Re: task 4
— Expand Paste to full width of browser