Multiple table query as a single table

[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?

[shivabharat]

learn more about JOIN if u have MYSQL manual do have a look

 

SELECT t1.name, t2.salary FROM employee AS t1, info AS t2  WHERE t1.name = t2.name;