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
David Sabine
Posted on
SQL Joins Infographic
For further actions, you may consider blocking this person and/or reporting abuse
Top comments (1)
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...