Explain briefly the term an outer join

Question

Explain briefly the term an outer join?

Answer 1

An outer join comprises the records which those and match that do not have a matching value in any other table. Outer joins can be a LEFT outer join (or includes all records from the first table listed) or a RIGHT outer joins (or includes all records from the second table listed). Outer joins are not easily employed with more than the two tables.