Question : self join example
Answered by : brave-bee-bnlxqqvk7wdp
SELECT e.first_name + ' ' + e.last_name employee, m.first_name + ' ' + m.last_name manager
FROM sales.staffs e
INNER JOIN sales.staffs m ON m.staff_id = e.manager_id
ORDER BY manager;Source : | Last Update : Fri, 12 Jun 20
Question : SQL Self Join
Answered by : super-stoat-s3lkh6fnietq
SELECT column_name(s)
FROM table1 T1, table1 T2
WHERE condition;Source : | Last Update : Mon, 12 Oct 20