I have been getting a lot of good feedback on twitter lately about the JOIN Types poster.
Download the Join Types poster today for FREE!
Available for both SQL Server (TSQL) and MySQL.
Some of the join types covered are:
- Inner Join: Returns records that have matching values in both tables.
- Left (Outer) Join: Returns all records from the left table, and the matched records from the right table.
- Right (Outer) Join: Returns all records from the right table, and the matched records from the left table.
- Full (Outer) Join: Returns all records when there is a match in either the left or the right table.
- Cross Join: Returns the Cartesian product of rows from both tables.
- And much much more.
These join types and others are featured in my SQL join types poster.
Here is what people are saying on Twitter about the poster.
Trying to keep all of the different JOINs in mind, is pretty challenging. Especially after the coffee wears off for the day!
Use Steve Stedman’s JOIN Types cheat sheet to save time and avoid confusion on your next project:
Download the Join Types poster today for FREE!
Available for both SQL Server (TSQL) and MySQL.