Query problems
 

I expected to be able to select 2 tables and add each to
a single query create a primary key and the extract data
from one table into another. When I try to create a query
in Excel, it does not show me my other tables, just one.
Does anyone have any ideas about how to solve this?