Post reply

Simple SELECT Statement with LEFT JOIN

  • March 16, 2005 at 12:17 pm

    #547340

    IS NULL 

    not = NULL

    Using Left Joined columns in the WHERE clause converts the Join to an Inner join. An Inner Join, combined with the error of using "= Null" instead of "IS NULL" means no records get returned.

     

  • March 16, 2005 at 1:53 pm

    #547376

    Thank you!

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

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