At 08:51 PM 30-06-02 +0000, you wrote:

>Hi,
>
>I am building a query in a table and i am having a trouble sorting of
>data. here's my query
>
>select a.quantity * b.value as product
>from table a, table b
>where a.my_code = b.my_code
>/* order by a.quantity * b.value desc */

ORDER BY 1 DESC

heLen

All for Open and Open for All
Firebird Open SQL Database · http://firebirdsql.org ·
http://users.tpg.com.au/helebor/
_______________________________________________________