NOT IN

  • 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.

  • Great question, thanks.

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

  • 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 asks, "Can I join you?"
    Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

  • really good to know how NULLs can ruin your Friday

    Thanks for the question!

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

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