Tag: LEFT

TSQL JOIN Types Poster (Version 4)

So many times I have been asked for help with a query, where the question really comes down to the understanding of the difference between INNER and LEFT or RIGHT JOINs. I created this poster a few years ago and

Posted in TSQL Tagged with: , , , , , , ,

TSQL JOIN Types Poster (Version 3)

NOTE:: There is an updated version of the poster available now.   Version 4 is now available. So many times I have been asked for help with a query, where the question really comes down to the understanding of the difference

Posted in TSQL Tagged with: , , , ,

FULL OUTER JOIN vs CROSS JOIN

As I have been working on the SQL Server JOIN Types poster, I have received several questions around the difference between a CROSS JOIN, and a FULL OUTER JOIN. After looking at the Venn diagrams for the two, they are

Posted in Uncategorized Tagged with: , , , ,

TSQL OUTER JOINS (LEFT and RIGHT)

After learning the INNER JOIN when querying SQL Server, the LEFT OUTER JOIN and RIGHT OUTER JOIN are often what people attempt to learn next. The reason that I say attempt is that most people don’t get OUTER JOINs right the

Posted in 70-461 Training Tagged with: , , , , , , ,

SQL Server Join Types Poster (Version 2)

So many times I have been asked for help with a query, where the questoin really comes down to the understanding of the difference between INNER and LEFT or RIGHT JOINs. I created this poster a few years ago and

Posted in TSQL Tagged with: , , ,