Read this SQL tutorial to learn when to use SELECT, JOIN, subselects and ... database handles this type of statement, and you’re combining two or just a few tables, a simple SELECT statement ...