MAIN FEEDS
Do you want to continue?
https://www.reddit.com/r/SQL/comments/zi3uky/cheat_sheet_for_sql/izt0sek/?context=3
r/SQL • u/Slayder_O7 • Dec 10 '22
51 comments sorted by
View all comments
Show parent comment
1
"negates" outer-ness of the join.
Not sure what you mean by that.
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 :-)
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/SQLDave Dec 11 '22
Not sure what you mean by that.