Re: task 4

From Ivory Tortoise, 6 Months ago, written in Plain Text, viewed 206 times. This paste is a reply to task 4 from Ilya - view diff
URL http://codebin.org/view/ff93bc71 Embed
Download Paste or View Raw
  1. SELECT s.last_name AS employee_last_name,
  2.        ss.reports_to AS manager_last_name
  3. FROM staff AS s
  4. LEFT JOIN staff AS ss ON s.employee_id=ss.reports_to
  5. GROUP BY 1, 2
  6.  
  7. SELECT DISTINCT s.last_name AS employee_last_name,
  8.        ss.reports_to AS manager_last_name
  9. FROM staff AS s
  10. LEFT JOIN staff AS ss ON s.employee_id=ss.reports_to

Replies to Re: task 4 rss

Title Name Language When
Re: Re: task 4 Blush Motmot text 6 Months ago.
Re: Re: task 4 Mammoth Marten text 6 Months ago.

Reply to "Re: task 4"

Here you can reply to the paste above