As a non-DBA/developer, I’ve always found resources about SQL joins to be clunky.
I came across a resource recently that I found helpful: https://oracle-base.com/articles/misc/sql-for-beginners-joins
One thing I like about that list is: it accounts for join name synonyms (variations in join names) via the words in brackets.
Another thing I like: the list of join types is actually complete (unlike most join lists). For example, it includes information about CROSS JOIN LATERAL in the Additional Joins link, which is a join type that’s often overlooked (use case here).
In general, I really like oracle-base.com. It’s much better than the Oracle docs, which seems to be missing a lot of key information, are hard to read, and out-of-date. And seem to be meant for people who are already experts on the content. Whereas oracle-base.com is the opposite of all those things.
Many people will already know about that resource, but some might not, so I thought I’d share.
Cheers.
