SELF JOIN

Modified on Tue, 6 Oct, 2020 at 8:57 PM

A Self join is a join in which it is joined with the table itself based on the condition. 

For e.g. The below employee table contains the details such as Employee ID, Employee Name, their Supervisor’s Employee ID. 

To get the supervisor name for all the employees,   a self join on the employee’s supervisor ID with Employee ID can be performed.




Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article