top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

How is natural join on table with itself is done, please explain with examples?

+2 votes
266 views
How is natural join on table with itself is done, please explain with examples?
posted Jun 26, 2018 by anonymous

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

+2 votes

You use a self join when a table references data in itself.

E.g., an Employee table may have a SupervisorID column that points to the employee that is the boss of the current employee.

To query the data and get information for both people in one row, you could self join like this:

select e1.EmployeeID,
e1.FirstName,
e1.LastName,
e1.SupervisorID,
e2.FirstName as SupervisorFirstName,
e2.LastName as SupervisorLastName
from Employee e1
left outer join Employee e2 on e1.SupervisorID = e2.EmployeeID

answer Mar 15, 2019 by Rushabh Verma R.
...