Sql 301 YG SUDAH 208 Selama Tahun 2005

MENCARI
BERKAS,TAHUN,NAMA PEMOHON,JENIS KEGIATAN,
301 YG SUDAH 208 Selama Tahun 2005

select inde.masterpk1,
desa.desanam,
expe.expecod,
expe.expeyea,
shak.shaknam Pemohon,
tind.tindcod,
tind.tinddes,
d301.d301seq,
d301.d301yea,
d208.d208seq,
d208.d208yea
from expe,shak,tind,suex,d301,d208
where expe.expeyea=2005
and suex.expeid=expe.expeid
and suex.suexflgapp="Y"
and shak.shakcod=suex.shakcod
and d301.expeid=expe.expeid
and d208.expeid=expe.expeid
and d301.indecod=d208.indecod
and inde.indecod=d301.indecod
and desa.desaco8=inde.masterpk1
and tind.tindcod=d301.tindcod;

Yang 301 belum 208 belum ketemu, sory ya.. bentar.

select expe.expecod,
expe.expeyea,
shak.shaknam Pemohon,
tind.tindcod,
tind.tinddes,
d301.d301seq,
d301.d301yea
from expe,shak,tind,suex,d301,a
where expe.expeyea=2005
and suex.expeid<>a.expeid
and suex.suexflgapp="Y"
and shak.shakcod=suex.shakcod
and d301.expeid<>a.expeid
and tind.tindcod=d301.tindcod;
021 8973832