sorting data with aggregatefield in sql statement

From: Sudianto Atek (ijux_at_hotmail.com)
Date: 06/29/04


Date: Tue, 29 Jun 2004 17:23:02 +0700


 I have sql statement:
select Trans1.FLID, sum(PointFL) as JmlPoint, msFrontLiner.NmFrontLiner
from Trans1, msFrontLiner
where Trans1.FLID=msFrontLiner.FLID
group by Trans1.FLID, msFrontLiner.NmFrontLiner
order by JmlPoint Desc

How can I set order by "JmlPoint Desc" ?