>I have this SQL:
>
>

>SELECT A.zdesc, A.zone, ;
>       B.cdesc, B.ctype, ;
>       NVL(B.ncnt,0) AS pccnt, ;
>       NVL(C.ncnt,0) AS dccnt, ;
>       NVL(D.ncnt,0) AS ptcnt, ;
>       NVL(D.ncnt,0) AS dtcnt ;
>   FROM allzones A, p_ccnt B, d_ccnt C, p_tcnt D, d_tcnt E  ;
>   INTO CURSOR zsum ;
>   WHERE ???
>

>
Just use LEFT JOIN to add all the others to A

something like

...
FROM allzones A ;
   LEFT JOIN p_ccnt B ;
         ON a.iID = b.iZoneID ;
   LEFT JOIN d_ccnt C ;
         ON a.iID = C.iZoneID ;
   LEFT JOIN p_tcnt D ;
         ON a.iID = D.iZoneID ;
   LEFT JOIN d_tcnt E ;
         ON a.iID = E.iZoneID ;
...

Arnon