Hello
BM> Are you looking to compare a few last records in each table or ??
BM> Can I get a little bit more details?
I have 10 similar tables. 3 years ago it was one big table. Now I
split it to 10 tables.
3 years ago I could write:
SELECT * from BigTable WHERE date_col>$some_date ORDER BY date_col
Now I have to write:
SELECT * from Table0 WHERE date_col>$some_date
UNION
SELECT * from Table1 WHERE date_col>$some_date
...
UNION
SELECT * from Table9 WHERE date_col>$some_date
after push this rows into temporary table and after write:
SELECT * from TempTable ORDER BY date_col
How to make it simply and faster?
Sincerely,
Michael,
http://xoib.com/ http://3d2f.com/
http://qaix.com/ http://ryxi.com/
http://gyxe.com/ http://gyxu.com/
http://xywe.com/ http://xyqe.com/
