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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Can anyone explain a 'Right Join'?

Status
Not open for further replies.

scramble

Programmer
Jan 2, 2001
1
0
0
CA
I'm just curious.
 
The result set from a Right join includes all the records in which the linked field value in both tables is an exact match. It also includes a row for every record in the lookup (right) table for which the linked field value has no match in the primary table.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top