What happened to the Messenger Plus! forums on msghelp.net?
Shoutbox » MsgHelp Archive » Skype & Technology » Tech Talk » SQL Help (Joins)

SQL Help (Joins)
Author: Message:
lordy
Senior Member
****


Posts: 853
Reputation: 24
35 / Male / Flag
Joined: Jul 2004
Status: Away
O.P. RE: SQL Help
I think I get it:

Inner Join - Returns rows from both tables where the condition(s) are matched.

Left Join - Returns all rows from the first table, and those rows from the second table where there is a match with the condition(s).

Right Join - Returns all rows from the second table and those rows from the first table where there is a match with the condition(s).

That is what I'm concluding from what I've read on that page... someone please confirm

This post was edited on 06-30-2006 at 01:25 AM by lordy.
06-30-2006 01:24 AM
Profile E-Mail PM Find Quote Report
« Next Oldest Return to Top Next Newest »

Messages In This Thread
SQL Help (Joins) - by lordy on 06-30-2006 at 12:28 AM
RE: SQL Help - by Jhrono on 06-30-2006 at 12:38 AM
RE: SQL Help - by lordy on 06-30-2006 at 01:24 AM
RE: SQL Help (Joins) - by Adeptus on 06-30-2006 at 02:10 AM
RE: SQL Help (Joins) - by lordy on 06-30-2006 at 02:36 AM


Threaded Mode | Linear Mode
View a Printable Version
Send this Thread to a Friend
Subscribe | Add to Favorites
Rate This Thread:

Forum Jump:

Forum Rules:
You cannot post new threads
You cannot post replies
You cannot post attachments
You can edit your posts
HTML is Off
myCode is On
Smilies are On
[img] Code is On