Explain Self Join with the help of an example?

Chaitali

• Sep 29th, 2015

Self join - Joining table itself called "Self join". In Self join we need to use alias for the same table.
Example -

SELECT E.EmpID, E.Name, M.Name As Manager Name
FROM Employee E SELF JOIN Employee M
WHERE E.MgrID = M.EmpID

asifeqbal

 Profile Answers by asifeqbal Questions by asifeqbal

• Mar 19th, 2015

The Join in which a table joined itself are called Self Join.

Code
SELECT M1.Name, M2.Name
FROM Manager M1 JOIN Manager M2 ON M1.EmpId=M2.EmpId

Answer Question  Select Best Answer