Inner Join vs. Outer Join
A SQL Server inner join is a type of join that combines records from two or more tables in a database based on the values of the joined columns from each table. Inner joins only return rows that have matching values in the joined columns. In contrast, an outer join will return all rows from one table, and any matching …