[Solved] Using a case statement in data validation

Question

Try to use or operator like this:

select *
from t1
join t2 on t1.id = t2.id
        and ((t1.ROE = 1 and t2.Currency1 = t2.Currency2) or(t1.ROE <> 1 and t1.ROE = t2.ROE))

Accepted Answer

Try to use or operator like this:

select *
from t1
join t2 on t1.id = t2.id
        and ((t1.ROE = 1 and t2.Currency1 = t2.Currency2) or(t1.ROE <> 1 and t1.ROE = t2.ROE))