SQL hitung jumlah nilai ht perbank

select sum(moggamo),mogg.moggyea, mogg.moggseq,mogg.moggamo,
shakinde.indecod, inde.tdoccod,shak.shaknam
from inde,mogg,shakinde,shak
where tdoccod="B6"
and tsubcod="05"
and moggflgact="Y"
and moggyea=2003
and mogg.moggyea=inde.masterpk1
and mogg.moggseq=inde.masterpk2
and inde.indecod=shakinde.indecod
and shak.shakcod=shakinde.shakcod
group by shak.shaknam, mogg.moggyea, mogg.moggseq,mogg.moggamo,
shakinde.indecod, inde.tdoccod


MENCARI JML LUAS YANG DI TANGGUNGKAN

{SELECT paht.desaco8, paht.thakcod, sum(gssu.gssuare),

FROM paht,gssu,inde,mogg,gsht,gssuold,otht
WHERE tindcod="06"
and moggflgact="Y"
and moggyea=2003
and paht.desaco8=inde.masterpk1
AND paht.thakcod =inde.masterpk2
AND paht.htanseq =inde.masterpk3
AND gssu.desaco8 =paht.desaco8
AND gssu.gssuyea = paht.gssuyea
AND gssu.gssunum = paht.gssunum
and gsht.desaco8=inde.masterpk1
and gsht.thakcod=inde.masterpk2
and gsht.htanseq = inde.masterpk3
and gssuold.desaco8=
group by paht.desaco8, paht.thakcod}


*********************************************
MENCARI JML NILAI HT PER BANK

select shak.shaknam, sum(moggamo)
from inde,mogg,shakinde,shak
where tdoccod="B6"
and tsubcod="05"
and moggflgact="Y"
and moggyea=2003
and moggamo<>0
and mogg.moggyea=inde.masterpk1
and mogg.moggseq=inde.masterpk2
and inde.indecod=shakinde.indecod
and shak.shakcod=shakinde.shakcod
group by shak.shaknam
order by shak.shaknam

***********************************************