>>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 ??? >>>>
>... >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 ; >... > >>