In all three types of outer joins, the columns in the result row that are from the unmatched row are set to missing values. In this example, you will first create an inner join that relates employee ...

WHERE is used to select rows from inner joins. ON is used to select rows from inner or outer joins. The expression is evaluated for each row from each table in the intermediate table described earlier ...