Latest Tutorials| Questions and Answers|Ask Questions?|Site Map

Home Answers Viewqa SQL What is Self Join?

Have Programming Question? Ask it here!

hemant kumar
What is Self Join?
1 Answer(s)      3 years and 9 months 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.


Related Tutorials/Questions & Answers: