SQL JOINS

Question

Post reply

SQL JOINS

chgn01

SSCarpal Tunnel

Points: 4405
More actions
January 8, 2013 at 8:20 pm

#287266

Comments posted to this topic are about the item SQL JOINS
--------------------------------------
;-)“Everything has beauty, but not everyone sees it.” ― Confucius

Viewing 15 posts - 1 through 15 (of 33 total)

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

Ron McCullough SSC Guru Points: 63877 More actions · Answer 1

Nice back to basics question ..................... thanks

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read[/url]
Before posting a performance problem please read[/url]

Andre Ranieri SSCrazy Points: 2819 More actions · Answer 2

Nice question - I wonder if the question category should have been table aliases instead of joins

Thanks,

Andre Ranieri

Lokesh Vij SSChampion Points: 10836 More actions · Answer 3

Nice Question. Thanks!

~ Lokesh Vij

Guidelines for quicker answers on T-SQL question[/url]
Guidelines for answers on Performance questions

Link to my Blog Post --> www.SQLPathy.com[/url]

Follow me @Twitter

Dineshbabu Hall of Fame Points: 3220 More actions · Answer 4

Andre Ranieri (1/8/2013)
Nice question - I wonder if the question category should have been table aliases instead of joins
Thanks,
Andre Ranieri

+1

--
Dineshbabu
Desire to learn new things..

Koen Verbeeck SSC Guru Points: 259155 More actions · Answer 5

Not sure what this question tries to teach us.

I spend 5 minutes looking for a mistake, only to finally decide there wasn't one, all joins seemed legit. I got it right, but I suddenly was surprised the question was about table aliases.

Maybe I was more surprised that apparently the criteria for a query to run succesfully is to get your table aliases correct

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

sqlnaive SSCoach Points: 17437 More actions · Answer 6

Dineshbabu (1/8/2013)
Andre Ranieri (1/8/2013)
Nice question - I wonder if the question category should have been table aliases instead of joins
Thanks,
Andre Ranieri
+1

I agree with both Andre and Dineshbabu. Was looking for any issues in the joins for couple of minutes but found no issues.

kupy SSCommitted Points: 1652 More actions · Answer 7

Koen Verbeeck (1/8/2013)
Not sure what this question tries to teach us.
I spend 5 minutes looking for a mistake, only to finally decide there wasn't one, all joins seemed legit. I got it right, but I suddenly was surprised the question was about table aliases.
Maybe I was more surprised that apparently the criteria for a query to run succesfully is to get your table aliases correct

+1

Carlo Romagnano SSC-Insane Points: 22749 More actions · Answer 8

Koen Verbeeck (1/8/2013)
Not sure what this question tries to teach us.
I spend 5 minutes looking for a mistake, only to finally decide there wasn't one, all joins seemed legit. I got it right, but I suddenly was surprised the question was about table aliases.
Maybe I was more surprised that apparently the criteria for a query to run succesfully is to get your table aliases correct

Boh?!!:smooooth:

Stuart Davies SSCoach Points: 19505 More actions · Answer 9

Thanks for the question - and the easy point.

-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx

Gazareth One Orange Chip Points: 27737 More actions · Answer 10

Koen Verbeeck (1/8/2013)
Not sure what this question tries to teach us.
I spend 5 minutes looking for a mistake, only to finally decide there wasn't one, all joins seemed legit. I got it right, but I suddenly was surprised the question was about table aliases.
Maybe I was more surprised that apparently the criteria for a query to run succesfully is to get your table aliases correct

Couldn't see a problem in the syntax but went for no as I couldn't see the point of the answer being yes!

David Betteridge Hall of Fame Points: 3264 More actions · Answer 11

Couldn't see a problem in the syntax but went for no as I couldn't see the point of the answer being yes!

Me too :unsure:

(Bob Brown) SSCrazy Points: 2705 More actions · Answer 12

(Bob Brown)

SSCrazy

Points: 2705

January 9, 2013 at 5:22 am

#1575186

Thanks for the question.

Toreador SSChampion Points: 11375 More actions · Answer 13

Saw the question title and the SQL and thought this would be a useful question about joins.

Was about disappointed to find it was a yes/no question rather than about the expected results (how many would have been caught out by the left join to TT2 with the criterion on that table in the WHERE clause?).

Turned out not to be a question about joins at all, but about table aliases - which makes it even more trivial!

Very strange.

Raghavendra Mudugal SSChampion Points: 10658 More actions · Answer 14

Koen Verbeeck (1/8/2013)
Not sure what this question tries to teach us....

I guess.. this; if the aliases are been removed in SELECT block, it gives below error on ambiguity for couple of column names. (some sort.... author might had in mind)

Msg 209, Level 16, State 1, Line 3

Ambiguous column name 'Name2'.

Msg 209, Level 16, State 1, Line 4

Ambiguous column name 'Name3'.

(looks like this was one of the "out of the box" experience )

ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

SQL JOINS

Cookies on SQLServerCentral