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.

[eluser]PV-Patrick[/eluser]
Thanks for the correction darkhouse! I had already figured that out some time ago but I just decided to not be lazy and redid the entire database design. Works like it should now, amazing how that works...

[eluser]darkhouse[/eluser]
Yeah I was wondering what your schema was like, and thought it could probably be written a little better. Usually if you find you need to something a little unorthodox it means you're doing something wrong.

Glad you sorted it out.