Cari berkas, 208, 305 dan alas Hak

Cari berkas, 208, 305 dan alas Hak

select distinct expe.expecod,expe.expeyea,
d208.d208typ,d208.d208seq,d208.d208yea,
d305.d305typ,d305.d305seq,d305.d305yea,
inde.masterpk1,inde.masterpk2,inde.masterpk3
from expe,d208,d305,inde
where inde.tdoccod="B1"
and inde.indetyp="R"
and inde.tindcod=d208.tindcod
and expe.expeid=inde.expeid
and d208.expeid=expe.expeid
and expe.expeyea=2005
and year(d208.d208dat)=2005
and d208.expeid=d305.expeid;

Yang dihasilkan ada alas hak yang dobel karena tiap no 208 akan dimunculkan,
jadi diedit dulu ya...(lewat excel) unload dulu.
-----------------------------------------------------------------------------------------
Cari berkas, 208 dan 305 saja

select distinct expe.expecod,expe.expeyea,
d208.d208typ,d208.d208seq,d208.d208yea,
d305.d305typ,d305.d305seq,d305.d305yea
from expe,d208,d305
where d208.expeid=expe.expeid
and expe.expeyea=2005
and year(d208.d208dat)=2005
and d208.expeid=d305.expeid;
-----------------------------------------------------------------------------------------
nama pemohon, jenis kegiatan, letak

select distinct d208.d208seq,d208.d208yea,d208.d208typ,
d305.d305seq,d305.d305yea,d305.d305typ,tind.tinddes,
shak.shaknam,inde.masterpk1,inde.masterpk2,inde.masterpk3,
desa.desanam,keca.kecanam,expe.expecod,expe.expeyea
from expe,d208,d305,inde,tind,desa,keca,shak,suex
where expe.expeyea=2005
and expe.expeid=inde.expeid
and d208.expeid=expe.expeid
and year(d208.d208dat)=2005
and d208.expeid=d305.expeid
and inde.tdoccod="B1"
and inde.indetyp="R"
and suex.expeid=expe.expeid
and suex.shakcod=shak.shakcod
and inde.tindcod=d208.tindcod
and tind.tindcod=d208.tindcod
and desa.desanum8=inde.masterpk1
and keca.kecacod=desa.kecacod;