Use of CASE statement values in THEN expression
I am attempting to use a case statement but keep getting errors. Here's the statement: select TABLE1.acct, CASE WHEN TABLE1.acct_id in (select acct_id from TABLE2 group by acct_id having count(*) = 1 ) THEN ...