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

Unfortunately, that doesn't capture the fact that I need to link the catagories in the tripcount and clientcount. Thanks, though. I think Bret has the answer.

-Michelle