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 : 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
Question : Self-join
Answered by : defiant-dog-n3mmrasfopy6
select c1.Name , c2.Name As Boss
from emp1 c1 inner join emp2 c2 on c1.Boss_id = c2.IdSource : https://stackoverflow.com/questions/2458519/explanation-of-self-joins | Last Update : Sun, 29 Aug 21
Question : self join
Answered by : grieving-grebe-55kj4egf5xe3
1234SELECT columns FROM table A JOIN table B WHERE join_conditionsXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXSource : https://lms.clarusway.com/mod/lesson/view.php?id=3946&forceview=1 | Last Update : Mon, 19 Jul 21