Hi, Sorry my earlier reply won't work.

Hi Charles,

That helps. Thanks a lot.

Hi, Probably this may help.

select   t.employid, t.eacct_num, count(*) countid

from  transaction_table t

where t.enroll_ind = 3

and   exists (select 'x'

               from  dd00100  b

               where b.employid = t.employid)

group by t.employid, t.eacct_num