Cari 302 sudah 307

Cari 302 sudah 307.
-----------------------------------------
select expe.expecod,
expe.expeyea,
d302.d302seq,
d302.d302yea,
d307.d307seq,
d307.d307yea
from d302,d307,expe
where d302.d302yea=2006
and d302.expeid=expe.expeid
and d307.indecod=d302.indecod;

302 belum 307 (COBA INI MAS HINU)
----------------------------------------------
select distinct
expe.expecod,
expe.expeyea,
d302.d302seq,
d302.d302yea
from d302,expe
where d302.d302yea=2006
and d302.expeid=expe.expeid
and d302.indecod not in
(select indecod from d307);