Assuming VFP5.

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

>>Michelle,
>>
>>

>>SELECT Zone, Class, COUNT(Class) ;
>>  FROM MyTable ;
>> GROUP BY Class ;
>> ORDER BY Zone, Class ;
>> INTO CURSOR MyResult
>>

>
>That's slightly different from Ed's. Is there any difference in the results?
>
>Thanks,
>
>-Michelle