SQL 301 dan 208 per jenis kegiatan

select distinct expe.expecod,expe.expeyea,
d301.d301seq,
d301.d301yea,
d301.d301dat,
d208.d208seq,
d208.d208yea,
d208.d208dat,
shak.shaknam
from expe,d301,d208,suex,shak
where month(d301.d301dat)=2
year(d301.d301dat)=2006
and d301.expeid=expe.expeid
and d208.expeid=d301.expeid
and suex.expeid=expe.expeid
and shak.shakcod=suex.shakcod;

Nama-Pemohon dan jenis kegiatan
select distinct expe.expecod,expe.expeyea,
d301.d301seq,
d301.d301yea,
d301.d301dat,
d208.d208seq,
d208.d208yea,
d208.d208dat,
tind.tindcod,
tind.tinddes,
shak.shaknam
from expe,d301,d208,suex,shak,tind
where month(d301.d301dat)=2
and year(d301.d301dat)=2006
and d301.expeid=expe.expeid
and d208.expeid=d301.expeid
and d301.tindcod=tind.tindcod
and suex.expeid=expe.expeid
and shak.shakcod=suex.shakcod;

PER-SEKSI
select distinct expe.expecod,expe.expeyea,
d301.d301seq,
d301.d301yea,
d301.d301dat,
d208.d208seq,
d208.d208yea,
d208.d208dat,
d301.sesucod,
shak.shaknam
from expe,d301,d208,suex,shak
where month(d301.d301dat)=2
and year(d301.d301dat)=2006
and d301.expeid=expe.expeid
and d208.expeid=d301.expeid
and suex.expeid=expe.expeid
and shak.shakcod=suex.shakcod
order by d301.sesucod;