Nilai 301 Jual Beli dan Luasnya

select d301.d301seq No_d301,
d301.d301yea Tahun301,
inde.masterpk1 desa,
gssu.gssuare Luas,
akta.aktavalue NilaiJualBeli
from d301,inde,akta,gssu,paht
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;