I use delphi with interbase5.
I found out that it is inpossible to do a query like this:
select A.name, sum(B.value) from A,B
group by A.name
order by sum(B.value)
You can't "order by sum()"
In Microsoft accces this is (via ODBC) very easy.
Does anyone has a solution for this or a workaround ?