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 5 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,



Related Tutorials/Questions & Answers:
Advertisements
Advertisements
 

 

 

DMCA.com