Joins

Writing T-SQL Videos

In late 2018, I recorded a series of videos for APRESS publishing on how to write T-SQL Queries. (I have linked to the O’Reilly website below.) There are four titles in the series with each title about 45 minutes in length. The first is how to write a T-SQL SELECT…

SQL Join Types

Selecting From Multiple Tables

How to write T-SQL SELECT statements using multiple tables and what are the differences between using Inner Joins, Left Outer Joins, Right Outer Joins, and Full Outer Joins.