Post reply

Reg -Joins

  • February 14, 2014 at 7:30 am

    #1689076

    If you are using ID for the join you will get a Cartesian result.

    How do you know which row in table b belongs to each row in table a?

    Far away is close at hand in the images of elsewhere.
    Anon.

  • February 14, 2014 at 8:06 am

    #1689090

    I don't see anything (in common between the two) in that sample data that could help prevent the Cartesian product except maybe the dates.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

Viewing 2 posts - 1 through 3 (of 3 total)

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