SQL JUMLAH LUAS DARI DI303_Prayma

luas sertipikat dari 303 tahun 2004

(1) SEMUA SU
----------------------------------------------
select d303.tindcod,
tind.tinddes,
d303.d303seq,
d303.d303yea,
inde.tdoccod,
inde.masterpk1,
inde.masterpk2,
inde.masterpk3,
gssu.gssuare
from d303,inde,tind,gssu
where d303.d303yea=2005
and d303.indecod=inde.indecod
and inde.tdoccod="SU"
and d303.tindcod not in ("P1","P3","S1","90",
"S2","P7","P8","S8")
and tind.tindcod=d303.tindcod
and gssu.desaco8=inde.masterpk1
and gssu.gssuyea=inde.masterpk2
and gssu.gssunum=inde.masterpk3[1,8];

(2) SEMUA GS
----------------------------------------------
select d303.tindcod,
tind.tinddes,
d303.d303seq,
d303.d303yea,
inde.tdoccod,
inde.masterpk1,
inde.masterpk2,
inde.masterpk3,
gssuold.gssuare
from d303,inde,tind,gssuold
where d303.d303yea=2005
and d303.indecod=inde.indecod
and inde.tdoccod="GS"
and d303.tindcod not in ("P1","P3","S1","90",
"S2","P7","P8","S8")
and tind.tindcod=d303.tindcod
and gssuold.desaco8=inde.masterpk1
and gssuold.gssuyea=inde.masterpk2
and gssuold.gssunum=inde.masterpk3[1,8];

SQL (1) DAN (2) JIKA INGIN DI LOAD KE EXCEL KEMUDIAN DI EDIT SENDIRI

(3) YG SU
----------------------------------------------
select d303.tindcod,
tind.tinddes,
sum(gssu.gssuare) LUAS
from d303,inde,tind,gssu
where d303.d303yea=2005
and inde.tdoccod="SU"
and d303.indecod=inde.indecod
and d303.tindcod not in ("P1","P3","S1","90"
,"S2","P7","P8","S8")
and tind.tindcod=d303.tindcod
and gssu.desaco8=inde.masterpk1
and gssu.gssuyea=inde.masterpk2
and gssu.gssunum=inde.masterpk3[1,8]
group by 1,2;

(4) YG GS
------------------------------------------------------
select d303.tindcod,
tind.tinddes,
sum(gssuold.gssuare) LUAS
from d303,inde,tind,gssuold
where d303.d303yea=2005
and inde.tdoccod="GS"
and d303.indecod=inde.indecod
and d303.tindcod not in ("P1","P3","S1","90"
,"S2","P7","P8","S8")
and tind.tindcod=d303.tindcod
and gssuold.desaco8=inde.masterpk1
and gssuold.gssuyea=inde.masterpk2
and gssuold.gssunum=inde.masterpk3[1,8]
group by 1,2;

SQL (3) DAN (4) JUMLAH TOTALNYA SAJA, DUA2NYA DIEKSEKUSI
KEMUDIAN JUMLAHKAN MANUAL.
DI BAWAH INI SAMA HANYA TINDCODNYA (JENIS KEGIATAN) YANG
PENGECEKAN DAN SEBAGAINYA. DIBEDAKAN SQLNYA KARENA DI INDE
UNTUK KEGIATAN PENGECEKAN YG MUNCUL BUKU TANAH BUKAN SU/GS
KALAU YG KEGIATANNYA KUTIPAN SU DI INDE MUNCUL SU/GSNYA.

--------------------------------------------------------------------
SEMUA UNTUK GS (YG TINDNYA P1 DST)
------------------------------------------------------
select d303.tindcod,
tind.tinddes,
d303.d303seq,
d303.d303yea,
inde.tdoccod,
inde.masterpk1,
inde.masterpk2,
inde.masterpk3,
gssuold.gssuare
from d303,inde,tind,gsht,gssuold
where d303.d303yea=2005
and d303.indecod=inde.indecod
and d303.tindcod in ("P1","P3","S1","90",
"S2","P7","P8","S8")
and tind.tindcod=d303.tindcod
and gsht.desaco8=inde.masterpk1
and gsht.thakcod=inde.masterpk2
and gsht.htanseq=inde.masterpk3[1,8]
and gssuold.desaco8=gsht.desaco8
and gssuold.gssunum=gsht.gssunum
and gssuold.gssuyea=gsht.gssuyea
order by d303.d303seq;

SEMUA UNTUK SU (YG TINDNYA P1 DST)
------------------------------------------------------
select d303.tindcod,
tind.tinddes,
d303.d303seq,
d303.d303yea,
inde.tdoccod,
inde.masterpk1,
inde.masterpk2,
inde.masterpk3,
gssu.gssuare
from d303,inde,tind,paht,gssu
where d303.d303yea=2005
and d303.indecod=inde.indecod
and d303.tindcod in ("P1","P3","S1","90",
"S2","P7","P8","S8")
and tind.tindcod=d303.tindcod
and paht.desaco8=inde.masterpk1
and paht.thakcod=inde.masterpk2
and paht.htanseq=inde.masterpk3[1,8]
and gssu.desaco8=paht.desaco8
and gssu.gssunum=paht.gssunum
and gssu.gssuyea=paht.gssuyea
order by d303.d303seq;

JUMLAH TOTAL UNTUK GS (YG KEGIATANNYA P1 DST)
------------------------------------------------------------
select d303.tindcod,
tind.tinddes,
sum(gssuold.gssuare) JUMLAH
from d303,inde,tind,gsht,gssuold
where d303.d303yea=2005
and d303.indecod=inde.indecod
and d303.tindcod in ("P1","P3","S1","90",
"S2","P7","P8","S8")
and tind.tindcod=d303.tindcod
and gsht.desaco8=inde.masterpk1
and gsht.thakcod=inde.masterpk2
and gsht.htanseq=inde.masterpk3[1,8]
and gssuold.desaco8=gsht.desaco8
and gssuold.gssunum=gsht.gssunum
and gssuold.gssuyea=gsht.gssuyea
group by 1,2;

JUMLAH TOTAL UNTUK SU (YG KEGIATANNYA P1 DST)
------------------------------------------------------------
select d303.tindcod,
tind.tinddes,
sum(gssu.gssuare) JUMLAH
from d303,inde,tind,paht,gssu
where d303.d303yea=2005
and d303.indecod=inde.indecod
and d303.tindcod in ("P1","P3","S1","90",
"S2","P7","P8","S8")
and tind.tindcod=d303.tindcod
and paht.desaco8=inde.masterpk1
and paht.thakcod=inde.masterpk2
and paht.htanseq=inde.masterpk3[1,8]
and gssu.desaco8=paht.desaco8
and gssu.gssunum=paht.gssunum
and gssu.gssuyea=paht.gssuyea
group by 1,2;