However, this example comes from a real-world case ... most implementations of SQL support the INNER JOIN, LEFT JOIN, and RIGHT JOIN constructs. Once you’ve figured out how these three queries ...

Read this SQL tutorial to learn when to use SELECT, JOIN ... and FULL OUTER; INNER; and CROSS. The type you use is determined by the results you want to see. For example, using a LEFT OUTER ...