Order by date

Hi, I have a query from tables that give me records with two date "date1" and "date2". How can I order the records by the most recent date (between the two date) for each records ? Example: Data: IDdescriptiondate1date2 1 aaa09/03/02 09/05/02 2

Insert failed

Hi, I try to insert a new record in a table. The key is an automatic ID. The insert is refused due to duplicate key, but the key does not exist. Why ? Is it a bug ? Any idea ? Some help ? Thanks Xavier Details: The colums of the table: ++--+--+-+-