Read this SQL tutorial to learn when to use SELECT, JOIN, subselects and UNION to access multiple tables with ... statement is the most basic way to query multiple tables. You can call more ...

you would enter Music in the parameter query dialog box, as shown in Figure B. As you can see in Figure C, even though Music appears in the middle of the name, Access is still able to find the record.