HELP .. DISTINCT and a join - usually indicates loose programming. Replace by EXISTS

[kmesser]

select distinct(conv_acct_id) from lookup_exception where exists(select something from somewhere where condition=true);