I am needing to select the latest entries from two separate tables, each having date fields. The two tables are "events" and "news". I need the query to return the latest 5 entries from either table, so somehow the dates need to be compared with each other - or sorted - or ?. It's no prblem selecting the latest 5 from either table seperately, but I can't figure out how to select the latest five from BOTH tables, and return them from one query, sorted by date desc [whether the date in question comes from EITHER table].
It id not enough to order by news.date, events.date because the query would then return the latest 5 from news first, then look at events - even though a particular "event" may be newer then one or more of the 5 latest news entries.
Hope this makes sense...
HELP!
