Read this SQL tutorial to learn when to use SELECT ... This basic syntax is a simple INNER JOIN. Some databases treat it exactly the same as an explicit JOIN. The WHERE clause expresses the ...