The traditional way of adding a table from an external database into a query is by linking the table to your database.
There is another way, however.
In the query design grid, right click anywhere in the grey area.
Click Properties.
When the properties window pops up, type the full path of the external database in the Source Database box.
For additional information about designing Access Queries, see our course: Access Queries from A to Z.
