I am getting an error when I run the following query can any one help
me

create materialized view mv_bigtab as
select A.DLQ_STATUS,
count(*) Count,
nvl((select nvl(sum(T.LOAN_AMT-T.PRINC_PAID),0) from ALMST
T,COLLHIST F where
T.MONTHS_DUE_TD < F.MONTHS_DUE and
T.ACC_CLOSED <> 'C' and T.LOAN_NO=F.LOAN_NO
and A.DLQ_STATUS=F.DLQ_STATUS and A.DLQ_STATUS=T.DLQ_STATUS),0)
Stab,
nvl((select nvl(sum(T.LOAN_AMT-T.PRINC_PAID),0) from ALMST
T,COLLHIST F where
T.MONTHS_DUE_TD > F.MONTHS_DUE and
T.ACC_CLOSED <> 'C' and T.LOAN_NO=F.LOAN_NO
and A.DLQ_STATUS>F.DLQ_STATUS and A.DLQ_STATUS=T.DLQ_STATUS
),0) Rf,
nvl((select nvl(sum(T.LOAN_AMT-T.PRINC_PAID),0) from ALMST
T,COLLHIST F where
T.MONTHS_DUE_TD < F.MONTHS_DUE and
T.ACC_CLOSED <> 'C' and T.LOAN_NO=F.LOAN_NO
and A.DLQ_STATUS<F.DLQ_STATUS and A.DLQ_STATUS=T.DLQ_STATUS),0)
Rb,
A.agency_code,
A.cas_code
from
almst A,collhist C
where
A.LOAN_NO=C.LOAN_NO and A.ACC_CLOSED <>'C'
group by
A.agency_code,A.cas_code,A.DLQ_STATUS

Regards
Don

Can you post the error messages with its complete text?

Thanks,
Brian

--
================================================== =================

Brian Peasland
oracle_dba@nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown