Access 2002: Merging two tables together as a query/view?

[TheElephantMan]

Hi, all.

I have two tables that have identical structure and different data. For eventual use in a report, I'd like to take the contents of each table and merge them together into one, in a query.

Table 1:
Fred 1
Jake 2
Bob 3

Table 2:
Fred 1
Jake 2
Jane 4
Mike 3

Query:
Fred 1
Jake 2
Bob 3
Fred 1
Jake 2
Jane 4
Mike 3

Is such a thing possible without getting into temporary tables and Macros/VB, or would I have to perform this programatically?

Thanks in advance,
TEM

 

[JonFer]

Use a Union query but look up the difference between Union and Union All first.