NOT IN

• Marcia J

  SSCertifiable

  Points: 5649

  More actions

  July 31, 2015 at 8:36 pm

  #1816599

  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: 259155

  More actions

  August 4, 2015 at 2:30 am

  #1817032

  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

  SSC-Dedicated

  Points: 31957

  More actions

  August 5, 2015 at 8:36 am

  #1817566

  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

• jackson.fabros

  Say Hey Kid

  Points: 674

  More actions

  August 21, 2015 at 4:05 pm

  #1821808

  really good to know how NULLs can ruin your Friday

  Thanks for the question!