>hi,
>thank you,
>sorry
>What do you mean "not work"? SUM( trn_qnty )...not work, no sum
>

No sum as in no records returned? If that is the case then check your WHERE clause to be sure there are records that meet the condition.