BUKU TANAH PAKAI HPL HGU

DESA|JENIS HAK|NO HAK|NO SK|TGL SK|TGL BERAKHIR SK|NAMA PEMILIK|NOMOR SU|THN SU|LUAS

YG GS
-------------------------------------------------------------
select desa.desanum8 KODE_DESA,
htan.thakcod JENIS_HAK,
htan.htanseq NO_HAK,
decr.decrcodbpn NO_SK,
decr.decrisudat TGL_SK,
decr.decrexpdat TGL_AKHIR_SK,
shak.shaknam PEMILIK,
gsht.gssunum NOMOR_SU,
gsht.gssuyea TAHUN_SU,
gssuold.gssuare LUAS
from htan,decr,desa,inde,shak,shakinde,gsht,gssuold
where htan.thakcod in ("2","4","5")
and decr.decrcod=htan.decrcod
and desa.desaco8=htan.desaco8
and inde.masterpk1=htan.desaco8
and inde.masterpk2=htan.thakcod
and inde.masterpk3[1,8]=htan.htanseq
and inde.indetyp="R"
and shakinde.indecod=inde.indecod
and shak.shakcod=shakinde.shakcod
and gsht.desaco8=htan.desaco8
and gsht.thakcod=htan.thakcod
and gsht.htanseq=htan.htanseq
and gssuold.desaco8=gsht.desaco8
and gssuold.gssuyea=gsht.gssuyea
and gssuold.gssunum=gsht.gssunum;

DESA|JENIS HAK|NO HAK|NO SK|TGL SK|TGL BERAKHIR SK|NAMA PEMILIK|NOMOR SU|THN SU|LUAS
YG SU
-------------------------------------------------------------------
select desa.desanum8 KODE_DESA,
htan.thakcod JENIS_HAK,
htan.htanseq NO_HAK,
decr.decrcodbpn NO_SK,
decr.decrisudat TGL_SK,
decr.decrexpdat TGL_AKHIR_SK,
shak.shaknam PEMILIK,
paht.gssunum NOMOR_SU,
paht.gssuyea TAHUN_SU,
gssu.gssuare LUAS
from htan,decr,desa,inde,shak,shakinde,paht,gssu
where htan.thakcod in ("2","4","5")
and decr.decrcod=htan.decrcod
and desa.desaco8=htan.desaco8
and inde.masterpk1=htan.desaco8
and inde.masterpk2=htan.thakcod
and inde.masterpk3[1,8]=htan.htanseq
and inde.indetyp="R"
and shakinde.indecod=inde.indecod
and shak.shakcod=shakinde.shakcod
and paht.desaco8=htan.desaco8
and paht.thakcod=htan.thakcod
and paht.htanseq=htan.htanseq
and gssu.desaco8=paht.desaco8
and gssu.gssuyea=paht.gssuyea
and gssu.gssunum=paht.gssunum;