SQL JOINs make it easy to find and fix missing ... even if there aren’t any matching values in the table on the right. In this example, the LEFT JOIN answers the following business question ...

returns all matching rows in both tables, in addition to rows in the left table that ... In all three types of outer joins, the columns in the result row that are from the unmatched row are set to ...