Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Posted on
- Combining results from two pairs of tables
May 8, 2006, 3:03 am
rate this thread
contains a session id, address and date. Linked to this I have a table
of items that make up each order. I'm concerned that over the course of
a few weeks performance will slow down as the tables fill up, so I
though I would make duplicates of each table and have any orders over a
month old moved (along with the corresponding items) to the duplicate
tables. I would appreciate any advice from anyone who has had a similar
problem on whether I'm going about this the right way, and secondly, is
there a way to write a query that will recombine the separated entries
into a single date-ordered list?
orders: session_id, name, address, date (PRIMARY: session_id)
items: session_id, item_no, item_name, price, date (PRIMARY:
old_orders: session_id, name, address, date (PRIMARY: session_id)
old_items: session_id, item_no, item_name, price, date (PRIMARY:
Re: Combining results from two pairs of tables
Check out the use of UNION or UNION ALL etc to join query results
"lost in thought"
- » Which is the right Directory to backup MySQL database on Linux Opearing system?
- — Previous thread in » MySQL Database Forum
- » Americanas.com SALDO de TVs Com at 80% de Desconto (29798)
- — Newest thread in » MySQL Database Forum