Sql Semua Jenis Kegiatan yang Arsip

select boxe.expecod,
boxe.expeyea,
tind.tinddes,
inde.masterpk3,
thak.thakdes,
desa.desanam,
keca.kecanam,
shak.shaknam
from boxe,thak,desa,keca,shak,suex,inde,tind
where boxe.ttasdes="Arsipkan Dokumen"
and year(boxe.start_date)=2006
and boxe.tproaliasexpe not in ("191","192","82","822","281")
and inde.expeid=boxe.expeid
and inde.tindcod<>"00"
and inde.tdoccod="B1"
and inde.indetyp="A"
and desa.desaco8=inde.masterpk1
and thak.thakcod=inde.masterpk2
and keca.kecacod=desa.kecacod
and suex.expeid=boxe.expeid
and suex.suextyp="A"
and shak.shakcod=suex.shakcod
and tind.tindcod=inde.tindcod;