tekstual - buku tanah dan annotasi

--Buku Tanah dan Annotasi
select *
from register a, reghat b, reghatanno c
where c.reghatid = b.regid
and c.regid = a.regid
and b.regid = c.reghatid
and b.desaid = '230B32B5CE5A4A5AE040A8C003001C9F'
and b.tipehakid = 1
and b.nomor = '1'
order by c.orderseq;

--Mencari Buku Tanah dengan Annotasi Pemisahan (12), Tetapi dimatikan (0)
select *
from register a, reghat b, reghatanno c
where c.reghatid = b.regid
and c.regid = a.regid
and b.regid = c.reghatid
and a.prosedurcode = '12' --Pemisahan
and b.hatstatus = '0'
;

--Mencari BT dengan Asal Persil Pemisahan (5)
--dengan regorg = 'DM'
select c.desaco8, a.kecanama, c.desanama,
b.tipehakid, b.nomor, d.regorg,
b.hatstatus
from kecamatan a, reghat b, desa c, register d
where a.kecamatanid = c.kecamatanid
and c.desaid = b.desaid
and d.regid = b.regid
and d.regorg = 'DM'
and b.asalpersilid = '5' --Pemisahan
and b.hatstatus = '1' --Status Aktif
and b.tipehakid = '3' --HGB
order by c.desaco8, b.tipehakid, b.nomor
;