Re: Re: task 4

From Blush Motmot, 1 Year ago, written in Plain Text, viewed 280 times. This paste is a reply to Re: task 4 from Ivory Tortoise - go back
URL http://codebin.org/view/f277c979/diff Embed
Viewing differences between Re: task 4 and Re: Re: task 4
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

Replies to Re: Re: task 4 rss

Title Name Language When
Re: Re: Re: task 4 Emerald Owl text 1 Year ago.

Reply to "Re: Re: task 4"

Here you can reply to the paste above