selecting * from two tables with datetime and sorting

[Phire]

I've got two tables that have datetime columns, I want to select all columns from both tables, but I want to sort descending by the datetime columns while taking into account the datetimes from both tables.

select * from tableone, tabletwo order by datetimecolumn desc

it will give me an error saying datetimecolumn is ambiguous because it wants to sort from only 1 table's datetimecolumn. Is there a proper query for this?

[NogDog]

You may have to do something like:

ORDER BY table1.datetimecolumn DESC table2.datetimecolumn DESC

However, that's probably going to give you a lot of results unless you add some sort of join condition.