JUMLAH 301 PERJENIS KEGIATAN

select tind.tindcod,
tind.tinddes,
count(distinct d301.d301seq) JUMLAH_301
from tind,d301
where tind.tindcod=d301.tindcod
and year(d301.d301dat)=2006
group by 1,2;

-----------------------------------------------------
LIST 301 TAHUN 2006

select d301.d301seq NO_301,
d301.d301dat TGL_301,
d301.tindcod KODE_KEGIATAN,
tind.tinddes JENIS_KEGIATAN
from d301,tind
where tind.tindcod=d301.tindcod
and year(d301.d301dat)=2006;