Learn SQL: Microsoft SQL Server - Episode 16: Outer Join | Left and Right

In this last entry, I want to revisit how Join operations work, we know so far they will match the data from one table to another table and pull the joining records. However sometimes that might not be enough. In some cases you might want to pull the...