SQL ORDER BY Question URGENT...

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:

Code:

---

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

---

Help please... :)

Could you do the following.

Code:

---

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.

Yes it works fine... Thanks...