SQL JOINS

  • chgn01

    Hall of Fame

    Points: 3531

    Comments posted to this topic are about the item SQL JOINS

    --------------------------------------
    ;-)β€œEverything has beauty, but not everyone sees it.” ― Confucius

  • Ron McCullough

    SSC Guru

    Points: 63877

    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: 2759

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

    Thanks,

    Andre Ranieri

  • Lokesh Vij

    SSChampion

    Points: 10836

    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

    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: 258941

    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: 17435

    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: 1604

    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: 21793

    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: 18874

    Thanks for the question - and the easy point.

    -------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a questionThere 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

    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!

  • This was removed by the editor as SPAM

  • David Betteridge

    Hall of Fame

    Points: 3264

    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

    Thanks for the question.

  • Toreador

    SSChampion

    Points: 11231

    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.

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

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