Jump to content

Archived

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

jspash

Multiple table query as a single table

Recommended Posts

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?

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.