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



Home Answers Viewqa SQL What is Self Join?
Login         

View Questions and Answers by Category

Advertisements


 
Have Programming Question? Ask it here!
 
 
 


hemant kumar
What is Self Join?
1 Answer(s)      4 years 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
 

 

 

DMCA.com