Sql 301 belum 208

301 belum 208

select distinct expe.expecod,expe.expeyea,d301.d301seq,
d301.d301yea
from d208,d301,expe,inde,tind
where inde.tdoccod="B1"
and d301.expeid=expe.expeid
and d301.indecod=inde.indecod
and d301.sesucod=4003
and expe.expeyea=2004
and inde.masterpk2="3"
and inde.tindcod="31"
and inde.tindcod=tind.tindcod
and d301.tindcod=tind.tindcod
and month(expe.expedatini)="01"
and d301.expeid not in (select expeid from d208
where d208yea=2004);