Home Forums SQL Server 2008 T-SQL (SS2K8) Cannot get Left JOIN to work correctly RE: Cannot get Left JOIN to work correctly

  • August 24, 2012 at 2:18 am

    #1529603

    tshad (8/23/2012)

    Hi Cadavre,

    No problem.

    I understand what Chris had explained about the CROSS JOIN. I was trying apply that to the situation I have which I couldn't make work so I have been trying to start from the basic layout and add complexity to it to understand the process better.

    I have one more scenario that I am trying to put together that actually is one more table past this that is pretty much what my actual layout is like.

    I am trying to see if I can make it work first before I add the extra table to the sample to see if I can make it work.

    Thanks,

    Tom

    Can you post it here Tom with DDL and perhaps some sample data? It's time we put this one to bed 😉

    “Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw

    For fast, accurate and documented assistance in answering your questions, please read this article.
    Understanding and using APPLY, (I) and (II) Paul White
    Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden