I have two tables that I would like to treat as one:
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?
Multiple table query as a single table
1 reply to this topic
Posted 08 April 2003 - 05:50 PM
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;
Knowledge --- Reading Enriches Mind But Sharing Enhances It.[br][br]Note: Before you request help enusre that you have had a look at the tutorials @phpfreaks
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users