Read this SQL tutorial to learn when to use SELECT ... For example, using a LEFT OUTER JOIN will return all relevant rows from the first table listed, while potentially dropping rows from the ...