Jump to content


Multiple table query as a single table

  • Please log in to reply
1 reply to this topic

#1 jspash

  • New Members
  • Pip
  • Newbie
  • 1 posts
  • LocationLondon, England

Posted 08 April 2003 - 10:42 AM

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?

#2 shivabharat

  • Members
  • PipPipPip
  • Advanced Member
  • 371 posts
  • LocationChennai, India

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