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...

[Slaine]

Could you do the following.

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

I've not tried this out but I think it should work.

[MC_Claus]

Yes it works fine... Thanks...