An inner join it is the most common kind of join, so common that SQL doesn’t actually make us say “inner join” to do one.
An outer join returns a set of records or rows that include what an inner join would return, but also includes other rows for which no corresponding match is found in the other table. There are 3 types of outer join:
- Left join
- Right join
- Full join