How can rows from several tables be output in a single result set without a join condition being satisfied?
Unlike "normal" joins, outer joins also include rows in the result set which do not satisfy the join condition. In this case, the corresponding columns are set to NULL values.