is it possible to use a case in the where-clause of a statement ?
Sure - something like
WHERE a.acct_id = (CASE WHEN b.type=‘C’ then b.acct_id_1 else b.acct_id_2 END)
is it possible to use a case in the where-clause of a statement ?
Sure - something like
WHERE a.acct_id = (CASE WHEN b.type=‘C’ then b.acct_id_1 else b.acct_id_2 END)