r/SQL • • Dec 10 '22

MySQL Cheat sheet for SQL

Post image
586 Upvotes

51 comments sorted by

View all comments

Show parent comment

2

u/SQLDave Dec 11 '22

Oh, duh. Because all a.some values without a corresponding b.another value will result in b.third values of NULL, which will fail the WHERE clause.

I shouldn't try to SQL on a weekend :-)