i wants create a report turnover / sell orders.
To do that, i use this query :
select tdsls045.orno, tdsls045.amnt, tdsls045.odam
from tdsls045

now, i want a field "tdsls045.amnt - tdsls045.odam", and i want sort my layouts with this field.

How can I do that?
Help, me i am a new programmer with sql

Calculate the difference and store the value in a variable, in the program script itself. In the report layout, sort this variable as per your requirement.
Hope this helps.

hum???? Yeah but, when I say I am new with sql programming, I'm a really novice. ;)
Can you explain me more please. An example can help me.

extern domain tcqsl1 diff

{
select tdsls045.orno, tdsls045.amnt, tdsls045.odam
from tdsls045
where <condition>
selectdo
diff = (tdsls045.amnt - tdsls045.odam)
rprt_send()
endselect
}

Where, in the script, I must copy this sql?

how can I sort this calculated field?