>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>
