Cari HT nomor, peringkat,objek,pemegang Hak

SELECT htnomor nomor_ht, httahun tahun_ht, levelht peringkat, nilaiakta nilai_ht, a.jenishak jenis_hak_obyek, a.nomor nomor_obyek,
subyek.nama pemegang_hak_ht
FROM REGISTER,
reght,
akta,
regowner,
subyek,
(SELECT tipehakabbr jenishak, nomor, hthat2.reghtid
FROM reghat, tipehak, hthat hthat2
WHERE reghat.regid = hthat2.regobyekid
AND reghat.tipehakid = tipehak.tipehakid
UNION
SELECT 'HMS' jenishak, hmsnomor, hthat3.reghtid
FROM reghms, hthat hthat3
WHERE reghms.regid = hthat3.regobyekid) a
WHERE REGISTER.regid = reght.regid
AND REGISTER.aktaid = akta.aktaid
AND regowner.regid = REGISTER.regid
AND regowner.subyekid = subyek.subyekid
AND reght.regid = a.reghtid
ORDER BY 1, 2