I have several tables which all have the same format - ie. id, name, desc, date etc...
I need to take the newest five from all, ie. a union of all the table and order by date - however, MySQL doesn't support union and my version of MySQL (3.22) doesn't support temporary tables...
Does anyone know of a way of doing this?
Regards,
Ben Phillips.
