SQL and Join … an interesting guide to different types of JOIN


Perhaps the most powerful SQL feature is the JOIN operation. It is the envy of all non-relational databases, because the concept is so simple, yet so universally applicable, when you want to “…

Source: A Probably Incomplete, Comprehensive Guide to the Many Different Ways to JOIN Tables in SQL – Java, SQL and jOOQ.