What is the difference between an inner join and an outer join?

Question

What distinguishes an inner join from an outer join?

Answer 1

Inner join and outer join are two types of joins used in SQL to combine data from two or more tables. The main difference between an inner join and an outer join is in how they handle data that does not have a matching record in the other table.

An inner join only returns the records where there is a match in both tables. An outer join, on the other hand, returns all the records from one table and the matching records from the other table. If there is no matching record in the other table, the result will contain NULL values for the columns from the missing table. 

Take your database skills to the next level by mastering SQL joins with this video tutorial -