SQL PETUGAS UKUR_ PEMOHON_SU_LUAS

TGL MULAI|TGL SELESAI|BERKAS|THN BERKAS|PEMOHON|KODE DESA|NAMA DESA|

LUAS|NO SU|THN SU|NIP|NAMA PETUGAS UKUR

SELECT puex.puexinidat TGL_MULAI,
puex.puexenddat TGL_SELESAI,
expe.expecod NO_BERKAS,
expe.expeyea THN_BERKAS,
shak.shaknam NAMA_PEMOHON,
puex.puexdsa KODE_DESA,
desa.desanam DESA,
puex.puexare LUAS,
inde.masterpk3 NO_SU,
inde.masterpk2 THN_SU,
puexsub.emplnip NIP,
empl.emplnam NAMA_PETUGAS_UKUR
FROM puexsub,puex,expe,empl,desa,shak,inde,suex
WHERE empl.emplnip=puexsub.emplnip
AND puexsub.expeid=puex.expeid
AND puexsub.opernum=puex.opernum
AND puexsub.expeid=expe.expeid
AND desa.desaco8=puex.puexdsa
AND expe.stexcod<>"CA"
AND suex.expeid=expe.expeid
AND suex.suexflgapp="Y"
AND inde.expeid=expe.expeid
AND inde.indetyp="S"
AND inde.tindcod<>"00"
AND shak.shakcod=suex.shakcod
AND year(puex.puexinidat)=2006;

SELECT puex.puexinidat TGL_MULAI,
puex.puexenddat TGL_SELESAI,
expe.expecod NO_BERKAS,
expe.expeyea THN_BERKAS,
shak.shaknam NAMA_PEMOHON,
puex.puexdsa KODE_DESA,
desa.desanam DESA,
puex.puexare LUAS,
inde.masterpk3 NO_SU,
inde.masterpk2 THN_SU,
puex.emplnip NIP,
empl.emplnam NAMA_PETUGAS_UKUR
FROM puex,expe,empl,desa,shak,inde,suex
WHERE month(puex.puexinidat)="02"
AND year(puex.puexinidat)=2006
AND empl.emplnip="010158685"
AND puex.emplnip="010158685"
AND puex.expeid=expe.expeid
AND desa.desaco8=puex.puexdsa
AND expe.stexcod<>"CA"
AND suex.expeid=expe.expeid
AND suex.suexflgapp="Y"
AND inde.expeid=expe.expeid
AND inde.indetyp="S"
AND inde.tdoccod in ("GS","SU")
AND shak.shakcod=suex.shakcod;