SQL ORDER BY Question URGENT...

[MC_Claus]

Mjello...

I would like to order by the difference of two tables, but I does not seem like SQL supports this operation.
I have a field lets say Field1 and another field Field2 and would like to order by the difference between these two fields: Field1 - Field2

I'm hoping for an SQL Query a little like this:

Select * From TableName where Field1 > 10 ORDER BY (Field1 - Field2) DESC

Help please...