Sql Mencari Uang Pemasukan

Mencari Uang Pemasukan.

select inde.masterpk1 DESA,
inde.masterpk2 JENIS_HAK,
inde.masterpk3 NO_HAK,
decr.decramo PEMASUKAN,
d301.d301seq NO_301,
d301.d301yea THN_301,
d208.d208seq NO_208,
d208.d208yea THN_208
from inde,indedecr,decr,d301,d208
where inde.indecod=indedecr.indecod
and indedecr.decrcod=decr.decrcod
and decr.decramo is not null
and decr.decramo0
and d301.indecod=inde.indecod
and d208.indecod=inde.indecod;

Advertisement