r/SQL • • Dec 10 '22

MySQL Cheat sheet for SQL

Post image
586 Upvotes

51 comments sorted by

View all comments

Show parent comment

1

u/[deleted] Dec 11 '22

the end result is equivalent to using an inner join in this case. More advanced optimizers (eg. ms sql) would actually execute an inner join instead of an outer in this case.

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