SQL Joins Part 1 - Inner, Left Outer and Right Outer
this video series, we're going to talk about the most common types of joins used: - Inner Join - brings back only records that match each table based on the ON condition - Left Outer Join - brings back all records in the left table, any data that matches in the right table as well, and null for any data in the right table that didn't match the left table in the ON condition - Right Outer Join - brings back all records in the right table, any data that matches in the left table as well, and null for any data in th eleft table that didn't match the right table in the ON condition