Buat Nusyirwan “Uday” … Gua Kasih dah !!!!
SELECT d.desaco8, k.kecanama, d.desanama, rhs.hmsnomor, rg.gdnomor, rg.gdtahun, rh.tipehakid,
rh.nomor, s.nama, ro.ownerseq
FROM reghms rhs, regowner ro, subyek s, desa d, kecamatan k, apartment ap, hatpersil hp,
reghat rh, reggd rg
WHERE rhs.regid = ro.regid
AND ro.subyekid = s.subyekid
AND rhs.desaid = d.desaid
AND d.kecamatanid = k.kecamatanid
AND rhs.regid(+) = ap.reghrsid
AND ap.per_regid = hp.regpersilid
AND hp.reghatid = rh.regid
AND ap.reggdid = rg.regid
AND rh.hatstatus = ’1′
UNION
SELECT d.desaco8, k.kecanama, d.desanama, rhs.hmsnomor, rg.gdnomor, rg.gdtahun, rh.tipehakid,
rh.nomor, s.nama, rhsanno.orderseq
FROM reghms rhs, reghmsanno rhsanno, regowner ro, subyek s, desa d, kecamatan k,
apartment ap, hatpersil hp, reghat rh, reggd rg
WHERE rhs.regid = rhsanno.reghmsid
AND rhsanno.regid = ro.regid
AND ro.subyekid = s.subyekid
AND rhs.desaid = d.desaid
AND d.kecamatanid = k.kecamatanid
AND rhs.regid(+) = ap.reghrsid
AND ap.per_regid = hp.regpersilid
AND hp.reghatid = rh.regid
AND ap.reggdid = rg.regid
AND rh.hatstatus = ’1′
AND rhsanno.reghmsid = rhs.regid
ORDER BY 1, 4, 10
– Jo –
Filed under: SQL 2B, Tips and Tricks