Read this SQL tutorial to learn when to use SELECT, JOIN, subselects and UNION ... so we provide you with information for all vendors — even those that don’t pay us. A simple SELECT statement ...