Tag Archives: Joins
-
CROSS vs OUTER APPLY
2June 10, 2021 by Kenneth Fisher
I love CROSS APPLY. I also love OUTER APPLY. What’s the difference though? The same difference as with an INNER …
Continue reading -
Explain CROSS APPLY like I’m 5.
5May 11, 2020 by Kenneth Fisher
A good friend of mine (Randolph West (blog|twitter) asked that someone Explain CROSS APPLY like they are 5. So, here’s …
Continue reading -
What’s the difference between LEFT and RIGHT OUTER JOINs?
1August 3, 2016 by Kenneth Fisher
A DBA walked into a bar, saw a couple of tables, and asked “Can I JOIN you?” There are several …
Continue reading
SQL Studies 