TSQL Basics: SQL Server Join Types

Download PDF

Intended Audience

Database programmers and new administrators who are familiar with TRANSACT SQL, may know simple joins, who would like to know more about OUTER JOINS, LEFT JOINS, RIGHT JOINS, CROSS JOINS, and SELF JOINS.


What is the difference, and how can you use joins correctly. Sometimes an inner join is the right join type to use, other times the left outer join, right outer join, full outer join, cross join or self join. In this session you will first gain an understanding of the differences between each of these types of joins, and when they should be used. Then we’ll explore some common uses for joins, such as replacing a not in clause with join to get the same results with better performance. You will take home the right foundations to get at the data that you want.

Class Outline

  • What is a JOIN
  • Inner join
  • Left outer join
  • Right outer join
  • Full outer join
  • Cross join
  • Self join
  • Use Samples

One comment on “TSQL Basics: SQL Server Join Types
  1. Viola Shoell says:

    I am interested in such a class

Leave a Reply

Your email address will not be published. Required fields are marked *


SQL Server Performance Tuning

Need help with SQL Server Performance Tuning, contact Steve at Stedman Solutions, LLC for help, or take a look at the performance tuning page at the SteveStedman.com blog. We can help with tuning a single query or with figuring out why your SQL Server is running slow. Free 30 minute consultation.

Newsletter Signup

Stay informed of Database Corruption Challenge events, and other things happening at SteveStedman.com with my newsletter.
Newsletter signup form.

Stedman Solutions