>>Or:
>>

>>SELECT Fld1, SUM(Ammount) AS Ammount1;
>>       FROM crsTest1;
>>GROUP BY Fld1;
>>INTO CURSOR cTest1
>>
>>SELECT Fld1, SUM(Ammount) AS Ammount2;
>>       FROM crsTest2;
>>GROUP BY Fld1;
>>INTO CURSOR cTest2
>>
>>SELECT crsTest.Fld1,;
>>       cTest1.Ammount1,;
>>       cTest2.Ammount2;
>>FROM crsTest;
>>INNER JOIN cTest1 ON crsTest.Fld1 = cTest1.Fld1;
>>INNER JOIN cTest2 ON crsTest.Fld1 = cTest2.Fld1
>>

>
>You would use LEFT JOIN and it's even more steps <g>

Why? The steps are the same, just you must use
NVL(cTest1.Ammount1, 000000.00) AS Amount1,;