SELECT; Zones.Zone,; NVL(MyTable.Class, SPACE(8)) AS Class,; COUNT(Class) AS Cnt ; FROM; Zones; LEFT OUTER JOIN; MyTable ; ON Zones.Zone = MyTable.Zone; GROUP BY 1, 2 ; ORDER BY 1, 2 ; INTO CURSOR MyResult-myron kirby-
>>SELECT Zone, Class, COUNT(Class) ; >> FROM MyTable ; >> GROUP BY Class ; >> ORDER BY Zone, Class ; >> INTO CURSOR MyResult >>>