Problem ordering query results.... 1

[blondends]

HI,

I have a table that has 2 fields that hold dates. I am trying to order the results of the query so that the records with the most recent dates come out first. I can't work this one out - i can obviously return the results grouped by one of the date fields but not by both.

Any ideas ??

Chris

 

[JamesLean]

So you want to take the most recent of the tow dates for each row and then order by those, latest first?

ORDER BY CASE WHEN date1 > date2 THEN date1 ELSE date2 END DESC

--James

 

[blondends]

Excellent !! Thank you very much - that has help hours of reading and hair pulling !! STAR for you !!