SQL Jml luas yg ditanggungkan

SELECT paht.desaco8, paht.thakcod, sum(gssu.gssuare)
FROM paht,gssu,inde,mogg
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
group by paht.desaco8, paht.thakcod;

JML LUAS PER BULAN
select month(mogg.moggboodat) BULAN,
paht.desaco8 DESA,
paht.thakcod JENIS_HAK,
sum(gssu.gssuare) LUAS
from paht,gssu,inde,mogg
where inde.tindcod="06"
and mogg.moggflgact="Y"
and mogg.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
group by 1,paht.desaco8, paht.thakcod