SQL JOINS

  • Comments posted to this topic are about the item SQL JOINS

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

  • 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]

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

    Thanks,

    Andre Ranieri

  • 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

  • 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..

  • 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

  • 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.

  • 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

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

  • 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

  • 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

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

  • Thanks for the question.

  • 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 33 total)

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