p.prosedurdesc,s.keterangan,sum(p.persilarea)JumlahLuas
FROM berkasprosedur bp,regprosedur rp,prosedur p,register r,reghat rh,hatpersil hp,persil p,seksi s
WHERE rp.berkasprosedurid = bp.berkasprosedurid
AND bp.prosedurcode = p.prosedurcode
AND rp.origintype = ‘I’
AND r.regkode = ‘B1′
AND rp.regid = r.regid
AND r.regid = rh.regid
AND rh.regid = hp.reghatid
AND hp.regpersilid = p.regid
AND p.seksikode = s.seksikode
GROUP BY p.prosedurdesc,s.keterangan
Filed under: SQL 2B
cara membuat DI205 pada hak atas tanah