Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

What is a reflexive join? 1

Status
Not open for further replies.

StewartUK

Programmer
Feb 19, 2001
860
GB
I'm reading an article in FoxTalk and have come across this phrase.

Does anyone know what is meant by a reflexive join??

Thanks,

Stewart
 
Hi Stewart

A reflexive join exists when a table is joined to itself through a second column. For example, the table Employee(EmployeeID,...,ManagerID)could have a join from ManagerID to EmployeeID.

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top