I am using Firebird WI.T1.0.0.448 (aka Beta2)
and trying to do this :

SELECT P.ID_ALOJ_GRJ, V.JA_PEGO
FROM PEGA P JOIN V_ALOJ_GALPAO_PEGOS V ON (P.ID_ALOJ_GLP =
V.ID_ALOJ_GALPAO)
order by P.ID_ALOJ_GRJ

and I am getting this :

ID_ALOJ_GRJ JA_PEGO
112 4320
112 1837
112 4320
112 4320
114 16337 <----------- Why this wrong order ?
112 12421
112 12587
112 12587
112 12035

the situation worsens when I try to group the same resultset
with :

SELECT P.ID_ALOJ_GRJ, SUM(V.JA_PEGO)
FROM PEGA P JOIN V_ALOJ_GALPAO_PEGOS V ON (P.ID_ALOJ_GLP =
V.ID_ALOJ_GALPAO)
GROUP BY P.ID_ALOJ_GRJ

ID_ALOJ_GRJ SUM
112 14797
114 16337
112 49630

What kind of disaster is happening ?
Can anyone help me with this ?

(ID_ALOJ_GRJ is an integer column)

TIA,

MNobre

(I am an old user (Delphi programmer) of Interbase)