You can only select one table in each query; however, you can select additional tables to use in a report by creating an initialization query, a sequential query, or a detail query. When you create additional queries, you can use as many tables as you like. In addition, if your queries contain similar data, you can copy and modify an existing query.
Creating an Initialization Query