I'm wondering if this is possible.

I basicly want this:

select * from tableone LIMIT 10 ORDER BY date
select * from tabletwo LIMIT 10 ORDER BY date

But I only want it to show 10 ALL together.

I could go LIMIT 5 for each, and do one after the other, but I would prefer to make it so that if the last 10 things where put into tableone, then it would show 10 from tableone, and none from tabletwo, but if out of the last 10 out of both, 8 were tableone, 2 would show from tabletwo etc.

Any ideas?