Cari Hak Pakai Instansi Pemerintah

select distinct
keca.kecanam Kecamatan,
desa.desanam Desa,
inde.masterpk2 Kode_Hak,
thak.thakdes Jenis_Hak,
inde.masterpk3 No_Hak,
shak.shaknam Nama_Pemilik
From inde,indedecr,shak,shakinde,
desa,keca,thak
where indedecr.indecod=inde.indecod
and inde.masterpk2="4"
and thak.thakcod="4"
and shakinde.indecod=inde.indecod
and shak.tsubcod="02"
and shak.shakcod=shakinde.shakcod
and desa.desaco8=inde.masterpk1
and desa.kecacod=keca.kecacod
order by 2,5;