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!

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

Joins

Status
Not open for further replies.
audiopro

audiopro

Programmer
Apr 1, 2004
3,165
GB
Could someone point me to an explanation of the different types of JOIN.
LEFT, RIGHT, INNER, OUTER etc.
I can find syntax for all the instances but feel a discussion which compares the different types will be very useful.

Keith
 
Sort by date Sort by votes
Keith
There are a couple of good links in the FAQ area.
Kind regards
Clive
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

spamjim
  • Locked
  • Question
Is this resolved by joins?
Replies
1
Views
158
spamjim
spamjim
MAtkins59
  • Locked
  • Question
Query - multiple joins won't return any records.
Replies
19
Views
246
jpadie
jpadie
flyadvertising
  • Locked
  • Question
Multiple JOINS 1
Replies
3
Views
62
r937
r937
OsakaWebbie
  • Locked
  • Question
JOINs multiplying upon each other in aggregates 1
Replies
6
Views
51
OsakaWebbie
OsakaWebbie
admoore
  • Locked
  • Question
Problem w- aliases and multiple joins
Replies
2
Views
56
admoore
admoore

Part and Inventory Search

Sponsor

Back
Top