+2 votes
in Class 12 by kratos

Briefly describe an outer join.

1 Answer

+6 votes
by kratos
 
Best answer

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

...