Read this SQL tutorial to learn when to use SELECT, JOIN, subselects and UNION to access multiple tables with a single statement.

Figure A We’ll use these two tables to demonstrate how JOINs affect your queries. Notice that the Donors table contains five records, each representing a different person.