how to query on two linked tables

  • Thread starter Thread starter Patrick
  • Start date Start date
P

Patrick

I am new to access. I have a database that is too large
2gig, so I set up two databases each with a table that
Click to expand...
are identical in structure but the data is not the same. I
wish to be able to run a query off of these two tables. I
have linked the tables but cannot get a query to run that
will search for records in each table. Any help is
appreciated.
Thanks,
Patrick
 
First, create a union query that will give you the combined records from
both tables. Name it qryAllRecords and make its SQL statement similar to
this:
SELECT * FROM TableOne
UNION ALL
SELECT * FROM TableTwo;

Then create other queries that use this query as the table source. You then
can search, etc. on all the records together:

SELECT * FROM qryAllRecords
WHERE [FieldOfInterest] = "some value";
 
Back
Top