Proc 99

{Berkas Aktif}
select expe.expecod,expe.expeyea,tind.tinddes,task.user_ident,profile.description,expe.expedatini,expe.expedatend
from expe,tpro,expd,tind,task,profile
where tpro.tprocod=expe.tprocod
and tpro.tproalias = "99"
and expd.expeid = expe.expeid
and tind.tindcod = expd.tindcod
and task.expeid = expe.expeid
and task.stagcod = 2
and profile.ident = task.user_ident
group by expe.expecod,expe.expeyea,tind.tinddes,task.user_ident,profile.description,expe.expedatini,expe.expedatend;

{Berkas Selesai}
select expe.expecod,expe.expeyea,tind.tinddes,htas.user_ident,profile.description,expe.expedatini,expe.expedatend
from expe,tpro,expd,tind,htas,profile
where tpro.tprocod=expe.tprocod
and tpro.tproalias = "99"
and expd.expeid = expe.expeid
and tind.tindcod = expd.tindcod
and htas.expeid = expe.expeid
and htas.stagcod = 2
and profile.ident = htas.user_ident
group by expe.expecod,expe.expeyea,tind.tinddes,htas.user_ident,profile.description,expe.expedatini,expe.expedatend;