nilai jual beli dan nama pemilik

select d301.d301seq No_d301,
d301.d301yea Tahun301,
inde.masterpk1 desa,
inde.masterpk2 jenis_hak,
inde.masterpk3 no_hak,
shak.shaknam nama_pemilik,
gssu.gssuare Luas,
akta.aktavalue NilaiJualBeli

from d301,inde,akta,gssu,paht,shakinde,shak
where d301.indecod=akta.indecod
and d301.d301dat>="01/01/2007"
and d301.d301dat<="30/12/2007"
and d301.tindcod="31"
and d301.indecod=inde.indecod
and paht.desaco8 = inde.masterpk1
and paht.thakcod = inde.masterpk2
and paht.htanseq = inde.masterpk3
and gssu.desaco8 = paht.desaco8
and gssu.gssuyea = paht.gssuyea
and gssu.gssunum = paht.gssunum
and shakinde.indecod= inde.indecod
and shak.shakcod=shakinde.shakcod;