Post reply

LEFT JOIN Query help

  • August 11, 2009 at 1:53 pm

    #1037700

    Gianluca Sartori (8/11/2009)

    Whats the reason for putting one filter in ON cluase and the other filter in WHERE clause? why not both in ON or both in WHERE?

    If you put both conditions in the WHERE clause, you would make it behave as an INNER JOIN.

    This means that the query wouldn't return rows from TableA because they don't match your criteria on TableB.

    BTW, I am getting correct results for the query mentioned by Gianluca.

    Thanks for the help.

Viewing post 16 (of 15 total)

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