hemant kumar
What is Self Join?
1 Answer(s)      4 years and 7 months ago
Posted in : SQL

What is Self Join?

Advertisement
View Answers

November 18, 2010 at 5:58 PM


Hi,

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.

Thanks,