In SQL, an outer join is a type of join that returns the rows from one table and the matched rows from another table. If there is no match, the result is still returned, but with NULL values in the columns from the table that doesn't have a match.