I have been getting a lot of good feedback on twitter lately about the JOIN Types poster.
Hi, Steve Stedman here, and I want to share with you a poster that I have created that provides a visual representation of the different join types in SQL Server.
The poster is available at https://stedman.us/largePoster, and it is a print-on-demand product that can be ordered in a variety of sizes to suit your needs. The poster is designed to be a handy reference tool for SQL Server developers and database administrators, providing a quick and easy way to understand the different join types available in SQL Server.
The poster includes several different join types: inner join, left outer join, right outer join, cross join and more. Each join type is depicted in a different panel, making it easy to distinguish between them. The poster also includes a brief description of each join type, along with an example of how it is used in SQL Server.
The inner join is the most commonly used join type and is used to return only the rows that have matching values in both tables. The left outer join is used to return all the rows from the left table and the matching rows from the right table. The right outer join is similar to the left outer join, but it returns all the rows from the right table and the matching rows from the left table. Finally, the cross join returns the Cartesian product of the two tables, resulting in a combination of every row from both tables.
The poster is a great resource for anyone who works with SQL Server and needs to quickly understand the different join types. It is especially useful for those who are just starting out with SQL Server or who are looking to refresh their knowledge of join types. These join types and others are featured in my SQL join types poster.
Here is what people are saying on Twitter about the poster.
TSQL JOIN Types posterAdding a frame would really make it shine!
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.
Also available with print on demand delivered to you.
