Select on current and archive table.

[lugnutmonkey]

I have two tables. One is a collection of telephone call information. The other table is an archive of the first table and it contains all records that are over 3 years old. I would like to be able to run a select query that would let me see all the records as one continuous table.

Any suggestions as to how I can do this?

[orange]

Research Union query

[lugnutmonkey]

Thanks for the advice. I'll look into the Union query