- 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: Re: task 4
From Blush Motmot, 8 Months ago, written in Plain Text, viewed 208 times.
This paste is a reply to Re: task 4 from Ivory Tortoise
- view diff
URL http://codebin.org/view/f277c979
Embed
Download Paste or View Raw
— Expand Paste to full width of browser