[eluser]obiron2[/eluser]
You need to UNION all of the records together (you have already posted about this..)
then outside the UNION query you need to select from the union'ed dataset and order by date desc.
Code:
SELECT 'table1' as 'table_name', ID as 'ID', Date as 'Date' from table1
UNION
SELECT 'table2' as 'table_name', ID as 'ID', Date as 'Date' from table2
Note the addition of the fixed values table1 and table2 to ensure record uniqueness (assuming ID is unique within the table. then put the outer select around this. You will need to alias the union query so that you can do so.
Code:
SELECT myUnion.Table_name,myUnion.ID,myUnion.Date from
(
SELECT 'table1' as 'table_name', ID as 'ID', Date as 'Date' from table1
UNION
SELECT 'table2' as 'table_name', ID as 'ID', Date as 'Date' from table2
) myUnion
Order by myUnion.Date DESC
I think you may be trying to run before you can walk. Read some books or tutorials on SQL
Please note, the above code has not been tested.
Obiron