You can add more than one table to a query. When you add an additional table to a query using the Tables dialog, the Join Conditions dialogs open automatically. There are two Join Conditions dialog windows:
The Join Tables dialog box contains the following fields:
Use the Join Columns dialog box to specify the columns that will used to link the tables. The columns from the current table that you are adding to the query and the columns from each table that is already included in the query are listed. Select a column from each list box with the same data type (NUMERIC, DATE, TIME, or CHARACTER). Rows that have equal values in those columns will be joined.
The Join Columns dialog box contains the following fields: