Learn about SQL Joins on Multiple Columns

Learn about joining SQL Server tables together for a query when there is a need to join on multiple columns.

Join SQL Server tables where columns include NULL values

Dealing with NULL values especially when joining tables can become a challenge. Let's take a look at this issue and how this can be resolved.

Join Two CSV Files with a Common Column

In this example we will join two CSV files with a common column using SQL Server.

How Many Rows Returned

Collation, Unicode & Joins

SQL Server JOIN Hints

You, as a SQL Server data professional, are looking for ways to improve your queries. You've done the usual - avoided cursors and loops, used locks effectively, examined execution plans - what else can you tweak? Check out this tip to learn more.

Hash Join

Stairway to T-SQL DML Level 5: The Mathematics of SQL: Part 2

Joining tables is a crucial concept to understanding data relationships in a relational database. When you are working with your SQL Server data, you will often need to join tables to produce the results your application requires. Having a good understanding of set theory, and the mathematical operators available and how they are used to join tables will make it easier for you to retrieve the data you need from SQL Server.

Join Operations – Nested Loops

This is part I of III in a series on the physical join operators in SQL Server.

JOIN technique

another way to join the tables