Can someone give me an example where you
would use an exists rather then a distinct in a sql stmt?
DISTINCT and a join - usually indicates loose programming. Replace by EXISTS
ex: select distinct (conv_acct_id) from lookup_exception
what would the exists stmnt look like?