Re: Re: task 4

From Mammoth Marten, 11 Months ago, written in Plain Text, viewed 209 times. This paste is a reply to Re: task 4 from Ivory Tortoise - go back
URL http://codebin.org/view/6634e9de/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
U2FsdGVkX19uatJ4bbH/6v/dG5s5GGyR8ul5q9h0OErDWUhStMdXtjzo/+34t8H4edoeRwPO9daSimaSmrbzIAd8eULqwy4VnDv+
BmOW/s2RW8FY52Z9qURwg4FEs2Y3B+pLKBO9X+e3yl/H7hwAGYQWeraH2LCAHHBwHjnGC3MBUqSLA3dmL0RVbmIjvgkfXkkVPgpG
9sT/fUMWnBRP3hWeBFCUuBS5k8bDyeysEdPalgCG40J1+fUFz3CQWW3ksQht7oHEOB4whO9X5DA1Sd+edL9gDrqW93kqMXAvt4Iz
JWUjskRU4hg3KtwRC671bvwzUIWah906j3QN5BxBVXFgETlv0GF1lrBay3sXABoZdv1Lhr2TsHmaLaoAHdH4pKxoJW7btHDxEAn+
B7yA4oZkyZFBFF1cFTmjSEEWrI8=

Reply to "Re: Re: task 4"

Here you can reply to the paste above