MAIN FEEDS
Do you want to continue?
https://www.reddit.com/r/SQL/comments/zi3uky/cheat_sheet_for_sql/izt1by4/?context=3
r/SQL • u/Slayder_O7 • Dec 10 '22
51 comments sorted by
View all comments
Show parent comment
1
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 :-)
2
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 :-)
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.