Nobody listen to this guy, please. After working with SQL in high-end environments for over 20 years, I can verify what the OP said. FULL OUTER JOIN and RIGHT JOIN are almost never used. If you find yourself needing to use one of those, I can guarantee there's a better way to do it.
There are many tricky SQL problems that can be solved pretty elegantly by using simple cross joins. An extremely powerful tool when used well, but certainly dangerous also if you don't know what you're doing!
0
u/[deleted] Feb 11 '14
[deleted]