An outer join will list all rows in the specified table, even if those rows have no match in the other table. In SQL, outer join refers to left outer join, right outer join, or full outer join, which ensures that non-matching rows are also included in the result set with NULL values for columns from the other table.