In Microsoft Access, a Relationship helps you to merge or link data from one table to another. Relationships allow the user to create Queries, Forms, and Reports.

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

MS Access - Combining results from two different queries with different field names and tables 88merlin88 Nov 25, 2003 Jump to latest Follow Reply ...