>>>>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,;
>
>I meant you're using 3 selects, which is greater than 2. <g>

Yes, but no UNIONs :-)