Jump to content


Photo

Multiple table query as a single table


  • Please log in to reply
1 reply to this topic

#1 jspash

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

#2 shivabharat

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