hemant kumar
What is Self Join?
1 Answer(s)      5 years and a month ago
Posted in : SQL

What is Self Join?

View Answers

November 18, 2010 at 5:58 PM


A Self Join is a type of sql join which is used to join a table to itself, particularly when the table has a FOREIGN KEY that references its own PRIMARY KEY. It is necessary to ensure that the join statement defines an alias for both copies of the table to avoid column ambiguity.