NOT IN

  • Marcia J

    SSCertifiable

    Points: 5641

    rmechaber (7/28/2015)


    Here's a nice, straightforward -- but perhaps fuller -- explanation of what's going on here if you're still puzzled:

    https://www.simple-talk.com/sql/t-sql-programming/ten-common-sql-programming-mistakes/[/url]

    EDIT: URL corrected for the web-friendly version of the page instead of print preview.

    Rich

    Thanks. That was very helpful.

  • Koen Verbeeck

    SSC Guru

    Points: 258955

    Great question, thanks.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • webrunner

    One Orange Chip

    Points: 29988

    Thanks for the very helpful question. I got it wrong but learned a huge lesson today. NULL is some tricky ish.

    - webrunner

    -------------------
    A SQL query walks into a bar and sees two tables. He walks up to them and says Can I join you?
    Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

  • jackson.fabros

    Say Hey Kid

    Points: 667

    really good to know how NULLs can ruin your Friday

    Thanks for the question!

Viewing 4 posts - 16 through 19 (of 19 total)

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