SQL Joins

Question

Post reply

SQL Joins

Viewing 11 posts - 16 through 25 (of 25 total)

You must be logged in to reply to this topic. Login to reply

ankur_johari Newbie Points: 9 More actions · Answer 1

This article contains all the basic knowledge of joins,with the relevant and proper examples and explanations....

kinglion1109 Newbie Points: 3 More actions · Answer 2

kinglion1109

Newbie

Points: 3

August 14, 2009 at 12:45 pm

#1039624

Very good article.

Thordog Ten Centuries Points: 1322 More actions · Answer 3

I thought it was full of hot air... 😎

[font="Courier New"]____________________________________________________________________________________________
Remember as you walk down lifes road, don't forget to stop and pee on the bushes - Thordog[/font]

Misha_SQL SSCertifiable Points: 5407 More actions · Answer 4

Misha_SQL

SSCertifiable

Points: 5407

August 14, 2009 at 5:12 pm

#1039749

Nice refresher! Thank you.

tmeyer1969@gmail.com SSC Rookie Points: 33 More actions · Answer 5

nice article, but I'm puzzled by the statement that you "feel that people are afraid of Joins in SQL Server".

I mean, joins (inner/equi, at least) are one of the most basic things that someone has to know about T-SQL, learned in the same breath as 'select','update','delete','where', etc ...

Now if you said that outer, self and cross-apply joins are what people are afraid (or more likely unaware) of, I'd buy it. Otherwise, I'd say that the person didn't know jack about SQL if they don't know what a simple innner join is.

SQL Master-1143748 Newbie Points: 5 More actions · Answer 6

Hey Vivek, that's a really good article nicely written, expecting a few more tutorials/articles from you, keep up the good work:-)

c_atulbajaj Newbie Points: 9 More actions · Answer 7

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.

arthur.locke Grasshopper Points: 17 More actions · Answer 8

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.

ta.bu.shi.da.yu Hall of Fame Points: 3985 More actions · Answer 9

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

Random Technical Stuff[/url]

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 10

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, MVP, M.Sc (Comp Sci)
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

ta.bu.shi.da.yu Hall of Fame Points: 3985 More actions · Answer 11

Yow! But why would you want to?

Random Technical Stuff[/url]