From

This example uses the FROM clause to LEFT OUTER JOIN the products and categories tables based on the category_id in both tables. …