NOT IN

• Koen Verbeeck

  SSC Guru

  Points: 259197

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

  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!