JOIN With NULL Keys Returns ZERO Rows?!

JOINing tables with NULL keys returns ZERO rows! NULL = NULL in JOIN is FALSE. This breaks all join logic! Watch!

#sql #sqltricks #database #sqltutorial #join #nullkeys #sqlquiz #codingchallenge #sqlshorts #sqlbugs #joins #sqlwtf

https://www.youtube.com/watch?v=4PlkdCq4KnE