SQL 301 - 302 - 305 NILAI BELUM 208

SQL 301 - 302 - 305 NILAI BELUM 208

select expe.expeyea,
expe.expecod,
d301.d301seq,
d302.d302seq,
d305.d305seq,
sum(exco.excoamo) Nilai
from expe,d301,d302,d305,exco
where expe.expeyea=2005
and d301.expeid=expe.expeid
and d301.expeid not in (select expeid from d208
where d208yea=2005)
and d302.expeid=expe.expeid
and d302.expeid not in (select expeid from d208
where d208yea=2005)
and d305.expeid=expe.expeid
and d305.expeid not in (select expeid from d208
where d208yea=2005)
group by expe.expeyea,expe.expecod,d301.d301seq,
d302.d302seq,d305.d305seq;