Combining 3 mysql queries...

Python

Ok... I have 3 tables which have got content in them...

Now what I want to do is query each of them and get the 5 most recent which is easy... But then the results of these three queries I want to combine into one while statement so I can display them in order of date....

How can this be done?

So basically I want to combine the results of 3 mysql queries... order them by date and display.

Thanks