SQL Joins Infographic

Credit to C.L. Moffatt, 2008.

---

Joining tables in a SQL query is a powerful skill. This info graphic illustrates how each type of join behaves:

• LEFT JOIN
• RIGHT JOIN
• INNER JOIN
• FULL OUTER JOIN

Comments

[Nathan S.R.]

Thanks for this very useful post. I just wanted to add that, there is a very easy way now, to test all the SQLs described here, using the free & portable tools, mentioned in my latest post here : dev.to/linuxguist/learn-sql-quickl...