Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 3 of 3
  1. #1
    New Coder
    Join Date
    Feb 2004
    Posts
    13
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Retrieving NULL with IN Clause

    How do you retrieve NULL values using the IN Clause?

    Code:
    SELECT table1.Column1, table1.Column2, table2.Column3
    FROM table1
    LEFT OUTER JOIN table2 On table1.ID = table2.ID
    WHERE table2.Column3 IN (1,2,3, NULL?)
    It is possible for table2.column3 to be a NULL value because the left outer join may not return a row from table2, causing the table2.column3 value to be null. Using the IN Clause, what is the syntax for including NULL values? Thanks.

  • #2
    Senior Coder nikkiH's Avatar
    Join Date
    Jun 2005
    Location
    Near Chicago, IL, USA
    Posts
    1,973
    Thanks
    1
    Thanked 32 Times in 31 Posts
    Don't use NULL in the IN.

    SELECT table1.Column1, table1.Column2, table2.Column3
    FROM table1
    LEFT OUTER JOIN table2 On table1.ID = table2.ID
    WHERE (table2.Column3 IN (1,2,3) OR table2.Column3 is null)

    If this post contains any code, I may or may not have tested it. It's probably just example code, so no getting knickers in a bunch over a typo, OK? If it doesn't have basic error checking in it, such as object detection or checking if objects are null before using them, put that in there. I'm giving examples, not typing up your whole app for you. You run code at your own risk.
    Bored? Visit
    http://www.kaelisspace.com/

  • #3
    New Coder
    Join Date
    Feb 2004
    Posts
    13
    Thanks
    0
    Thanked 0 Times in 0 Posts
    ah thanks, I was looking at it the wrong way. Thanks for the help.


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •