SQL Laporan DI301 - HAT

select distinct db.dinomor, db.ditanggal, b.berkasnomor, b.berkasyear, b.berkasstatus, s.nama pemohon,
s.alamat, pembeli.keterangan, a.nomorakta, rh.tipehakid, rh.nomor, d.desanama, k.kecanama,
p.persilarea, penjual.nama penjual, pembeli.nama pembeli
from berkas b, dibook db, subyek s, subyekberkas sb, tipeowner t, berkasprosedur bp,
regprosedur rp, register r, reghat rh, desa d, kecamatan k, persil p, hatpersil hp,
akta a,
(select b.berkasid, s.nama, t.keterangan
from berkas b, berkasprosedur bp, akta a, subyekakta sa, subyek s, tipeowner t
where b.berkasid = bp.berkasid
and bp.berkasprosedurid = a.berkasprosedurid
and a.aktaid = sa.aktaid
and sa.subyekid = s.subyekid
and s.tipeownerid = t.tipeownerid) pembeli,
(select rh.regid, s.nama from reghat rh, regowner ro, subyek s
where ro.subyekid = s.subyekid(+)
and ro.regid = getlastowner(rh.regid)) penjual
where db.berkasid = b.berkasid
and db.dikode = 'DI301'
and b.kodespopp = 'SPOPP-3.20'
and b.berkasid = sb.berkasid
and sb.subyekid = s.subyekid
and b.berkasid = bp.berkasid
and bp.berkasprosedurid = rp.berkasprosedurid
and rp.origintype = 'I'
and rp.regid = r.regid
and rp.regid = rh.regid
and rh.desaid = d.desaid
and d.kecamatanid = k.kecamatanid
and rh.regid(+) = hp.reghatid
and hp.regpersilid = p.regid
and bp.berkasprosedurid = a.berkasprosedurid (+)
and b.berkasid = pembeli.berkasid
and rh.regid = penjual.regid
and b.berkasyear between 2005 and 2007
and b.berkasstatus = 1
group by db.dinomor, db.ditanggal, b.berkasnomor, b.berkasyear, b.berkasstatus, s.nama,
s.alamat, pembeli.keterangan, a.nomorakta, rh.tipehakid, rh.nomor, d.desanama, k.kecanama,
p.persilarea, penjual.nama, pembeli.nama, p.nib
order by 4,1;