Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««123

SQL Joins Expand / Collapse
Author
Message
Posted Friday, August 14, 2009 11:03 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, August 14, 2009 11:01 PM
Points: 1, Visits: 0
Hey Vivek, that's a really good article nicely written, expecting a few more tutorials/articles from you, keep up the good work
Post #771405
Posted Saturday, August 15, 2009 11:45 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, August 15, 2009 11:37 AM
Points: 1, Visits: 1
This article has given me a gud understanding of Joins in SQL.
The main thing about this article is that is its simplicity with which it describes Joins.

Thanx a lot.
Post #771496
Posted Sunday, August 16, 2009 4:26 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, August 10, 2010 1:25 AM
Points: 9, Visits: 65
I would like to see the article expanded to explain the difference between specifying joins in the FROM and WHERE clauses. In my experience, failure to understand the difference when using outer joins causes more problems than understanding the basic join types.
Post #771659
Posted Sunday, August 16, 2009 4:31 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Sunday, July 3, 2011 7:09 AM
Points: 233, Visits: 494
You can't do an outer join from the where clause...

Random Technical Stuff
Post #771660
Posted Monday, August 17, 2009 7:40 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 11:31 AM
Points: 40,177, Visits: 36,578
ta.bu.shi.da.yu (8/16/2009)
You can't do an outer join from the where clause...


You can't in a DB with compatibility set 90 or higher (ie SQL 2005 or 2008). It was possible on SQL 2000, but not recommended.



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #771897
Posted Monday, August 17, 2009 8:13 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Sunday, July 3, 2011 7:09 AM
Points: 233, Visits: 494
Yow! But why would you want to?

Random Technical Stuff
Post #771936
« Prev Topic | Next Topic »

Add to briefcase «««123

Permissions Expand / Collapse