SQL Joins

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Vivek Johari » SQL Joins

26 posts, Page 3 of 3

«««1 2 3

SQL Joins

Rate Topic

Display Mode

Topic Options

Author

Message

SQL Master-1143748

Posted Friday, August 14, 2009 11:03 PM

Forum 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 Smile

Post #771405

c_atulbajaj

Posted Saturday, August 15, 2009 11:45 AM

Forum 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

arthur.locke

Posted Sunday, August 16, 2009 4:26 PM

Forum 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

ta.bu.shi.da.yu

Posted Sunday, August 16, 2009 4:31 PM

SSC Veteran

Group: General Forum Members
Last Login: Sunday, July 03, 2011 7:09 AM
Points: 258, Visits: 494

You can't do an outer join from the where clause...

Random Technical Stuff

Post #771660

GilaMonster

Posted Monday, August 17, 2009 7:40 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 4:49 PM
Points: 37,722, Visits: 29,977

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

ta.bu.shi.da.yu

Posted Monday, August 17, 2009 8:13 AM

SSC Veteran

Group: General Forum Members
Last Login: Sunday, July 03, 2011 7:09 AM
Points: 258, Visits: 494

Yow! But why would you want to?

Random Technical Stuff

Post #771936

« Prev Topic | Next Topic »

26 posts, Page 3 of 3

«««1 2 3

Permissions