jspash

I have two tables that I would like to treat as one: table_one and table_one_archive Every month or so, I transfer a few thousand rows to the archive table so that the other table remains speedy. But on occasion I need to run a report that combines both tables as though they are one. If I do a \"select * from table_one, table_one_archive etc\" it smooshes everything together. Does this make sense? Any help please?