Ordering date fields from many tables

[MHIRI Souheil]

Hello,

I have to show order by recently entered article date from many articles.
Each table concerns an article and has its proper date field.

Exemple : I have camcorder table, camera table, tv table. Each table has a field date containing current date when we insert data in it. We want to order in a php page : recently posted articles.

Can someone help me to write the query.

THANKS !!!