Active Record + Join SQL Problem

[eluser]darkhouse[/eluser]
I must correct my initial statement. There actually IS a way to do this with SQL, and I didn't realize it. You can use a UNION. It's pretty simple really:

Code:

SELECT * FROM table1
UNION
SELECT * FROM table2
UNION
SELECT * FROM table3
UNION
SELECT * FROM table4
ORDER BY timestamp

Now, this should combine everything and order them all by the timestamp, BUT it might also combine other columns that shouldn't necessarily be combined. I'm not sure how to fix that exactly, just wanted you to be aware of it if it might be a problem for you.