Click here to Skip to main content
15,847,653 members
Home / Discussions / Database
   

Database

 
GeneralAlternative SQL Queries based on Table Data Pin
Jo Fredrickson3-Nov-03 22:58
Jo Fredrickson3-Nov-03 22:58 
GeneralRe: Alternative SQL Queries based on Table Data Pin
andyharman5-Nov-03 12:35
professionalandyharman5-Nov-03 12:35 
GeneralRe: Alternative SQL Queries based on Table Data Pin
Jo Fredrickson5-Nov-03 15:59
Jo Fredrickson5-Nov-03 15:59 
GeneralMSADO 2.5 Pin
Kant3-Nov-03 16:46
Kant3-Nov-03 16:46 
GeneralRe: MSADO 2.5 Pin
Mike Dimmick5-Nov-03 2:51
Mike Dimmick5-Nov-03 2:51 
GeneralRe: MSADO 2.5 Pin
Kant5-Nov-03 6:01
Kant5-Nov-03 6:01 
GeneralFULL LEFT/RIGHT JOIN Pin
devvvy3-Nov-03 13:53
devvvy3-Nov-03 13:53 
GeneralRe: FULL LEFT/RIGHT JOIN Pin
Jeff Varszegi3-Nov-03 15:28
professionalJeff Varszegi3-Nov-03 15:28 
I don't think there is such a thing as a FULL LEFT or FULL RIGHT join. There is, however, such a thing as a FULL OUTER JOIN-- is that what you're talking about? There are also LEFT OUTER JOIN and RIGHT OUTER JOIN. I can see how you could've become confused. Here's the skinny:

A LEFT OUTER JOIN is the same as a LEFT JOIN.
A RIGHT OUTER JOIN is the same as a RIGHT JOIN.
A FULL OUTER JOIN is the same as a FULL JOIN.

A LEFT JOIN is all the rows from the left part of a join, with NULL values being permitted on the right if there's no match.

A RIGHT JOIN is all the rows from the right part of a join, with NULL values being permitted on the left if there's no match.

A FULL JOIN is the union of a LEFT JOIN and a RIGHT JOIN; you're guaranteed that all possible rows from both the left and right will be present, with NULL values filling in the blanks on the other side as necessary.

Does this help?

Regards,

Jeff Varszegi
GeneralRe: FULL LEFT/RIGHT JOIN Pin
devvvy3-Nov-03 15:30
devvvy3-Nov-03 15:30 
GeneralTrouble Running Sql Script from Code Pin
perlmunger3-Nov-03 12:42
perlmunger3-Nov-03 12:42 
GeneralRe: Trouble Running Sql Script from Code Pin
Jeff Varszegi3-Nov-03 15:54
professionalJeff Varszegi3-Nov-03 15:54 
GeneralRe: Trouble Running Sql Script from Code Pin
perlmunger4-Nov-03 4:58
perlmunger4-Nov-03 4:58 
GeneralRe: Trouble Running Sql Script from Code Pin
Jeff Varszegi4-Nov-03 5:03
professionalJeff Varszegi4-Nov-03 5:03 
GeneralRe: Trouble Running Sql Script from Code Pin
perlmunger4-Nov-03 5:54
perlmunger4-Nov-03 5:54 
GeneralRe: Trouble Running Sql Script from Code Pin
Jeff Varszegi4-Nov-03 6:38
professionalJeff Varszegi4-Nov-03 6:38 
GeneralRe: Trouble Running Sql Script from Code Pin
perlmunger4-Nov-03 7:55
perlmunger4-Nov-03 7:55 
GeneralIdentity Seeds Pin
Colin Angus Mackay3-Nov-03 7:56
Colin Angus Mackay3-Nov-03 7:56 
GeneralHandling Disconnected Data In ADO.NET Pin
L Thomas3-Nov-03 6:10
L Thomas3-Nov-03 6:10 
Generalsql tables Pin
ranjjj31-Oct-03 4:14
ranjjj31-Oct-03 4:14 
GeneralRe: sql tables Pin
ranjjj31-Oct-03 4:18
ranjjj31-Oct-03 4:18 
GeneralDublication of rows Pin
Vaibhav Sanghavi30-Oct-03 23:15
Vaibhav Sanghavi30-Oct-03 23:15 
GeneralRe: Dublication of rows Pin
Rahul Walavalkar3-Nov-03 3:54
Rahul Walavalkar3-Nov-03 3:54 
GeneralRe: Dublication of rows Pin
Vaibhav Sanghavi3-Nov-03 4:10
Vaibhav Sanghavi3-Nov-03 4:10 
GeneralSystem.Data.Sqlclient.TdsParser Pin
yyf30-Oct-03 10:27
yyf30-Oct-03 10:27 
GeneralConnectionString.Timeout Pin
yyf30-Oct-03 9:06
yyf30-Oct-03 9:06 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.