Jump to content


This topic is now archived and is closed to further replies.


Multiple table query as a single table

Recommended Posts

I have two tables that I would like to treat as one:

table_one and



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?

Share this post

Link to post
Share on other sites

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;

Share this post

Link to post
Share on other sites


Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.