same criteria for querying two nearly identify tables

[delamerbleu]

I have two tables, which have same fields. The tables are used for keeping record of news clippings, that are clipped in two different offices. I understand that the best way to manage the database will be combining them into the same table. Yet, it's not an option for the time for some technical reasons. Each table has the same fields as follow:

Input date
issue date
headline in English
news source
category

I want to have a list of news clips from the two tables by a specific category. I will have a form, that allows user to select category as the criteria to query the two tables. I manage to do that in a single table, but how to do it for two tables. This will be very help if you can help. ideally, I can use category to query news clips as well as academic journal clips (from another table) table.

Thanks.

 

[RuralGuy]

Use a UNION query.

 

[neileg]

As RuralGuy says, a union query is the answer. You can either create a union that joins your two tables together and base your select query on that, or you can run tow select queries, one on each table, and union the results.