Database Joins

You'll find article covering several types of database joins including Inner Joins and Outer Joins.


It is important to learn about both inner and outer joins and they have different matching behavior.


I would start out with our article Introduction to Database Joins.


This first article introduces the concept of joining tables.  The focus is going to be more on the type of joins, not necessarily their syntax.  

The later articles focus on the various types of joins.  Through the narrative and examples you’ll become very comfortable with each one.


Some of our more popular articles include:


All the examples for this lesson are based on Microsoft SQL Server Management Studio and the sample databases AdventureWorks and WideWorldImporters.  You can get started using these free tools using my guide Getting Started Using SQL Server

Recommended Database Join Articles

Introduction to Database Joins
One of the biggest issues beginning SQL writers have is being able to write queries that use more than one[...]
Inner Join Introduction
An inner join is used when you need to match rows from two tables.  Rows that match remain in the[...]
Introduction to Outer Joins
Outer Joins Outer joins are used to match rows from two tables.  Even if there is no match rows are[...]
Is it possible to use Joins, Subqueries, and Unions in one Query?
A reader recently asked me to help them solve a problem combining data from multiple tables into a single result. [...]
Subqueries versus Joins
Joins and subqueries are both be used to query data from different tables and may even share the same query plan,[...]
What Is the Difference Between a Join and a UNION?
Both Joins and UNIONS can be used to combine data from two or more tables.  Read this article to find[...]
What is the Difference between Inner and Outer Joins?
Both inner and outer joins can be used to combine data from two or more tables; however, there are some[...]
Learn How to Combine Data with a CROSS JOIN
A cross join is used when you wish to create combination of every row from two tables.  All row combinations[...]
Joins versus Subqueries SQL Puzzle
In this puzzle, we’re going to learn about joins versus subqueries.  In many queries you can substitute joins and subqueries. [...]
How to Make a Join Easier to Read using Table Aliases
I recently put together a lesson on  table aliases and multi-table joins.  It is part of my Join Together Now[...]
What is a Non-Equi Join in SQL and What is its Purpose?
I recently put together a lesson on non-equi joins.  It is part of my Join Together Now course.  Click here[...]