Sql DI208 dg Luas SU

{LUAS SU SQL di bawah ini JALANKAN SATU KALI saja}
select inde.expeid,
gssu.gssuare
from inde,gssu
where inde.indetyp="S"
and inde.expeid is not null
and inde.expeid<>0
and gssu.desaco8=inde.masterpk1
and gssu.gssuyea=inde.masterpk2[1,4]
and gssu.gssunum=inde.masterpk3
into temp a;

{LUAS GS SQL di bawah ini JALANKAN SATU KALI saja}
select inde.expeid,
gssuold.gssuare
from inde,gssuold
where inde.indetyp="S"
and inde.expeid is not null
and inde.expeid<>0
and gssuold.desaco8=inde.masterpk1
and gssuold.gssuyea=inde.masterpk2[1,4]
and gssuold.gssunum=inde.masterpk3
into temp b;

{208 DG LUAS SU}
select d208.d208seq,
a.gssuare Luas_SU
from d208,a
where d208.d208yea=2005
and d208.expeid > 0
and a.expeid=d208.expeid;

{208 DG LUAS GS}
select d208.d208seq,
b.gssuare Luas_GS
from d208,b
where d208.d208yea=2005
and d208.expeid > 0
and b.expeid=d208.expeid;