suggest you try using If Then else if statement instead
if a.Emp_ID = 2000001
AND b.Group_type = 'REFUNDPTS'
THEN b.refill_points * - 1
a.rec_id = 2000001
AND a.Group_type= 'PURCHPTS'
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
I have tried it but i am getting different values from case statement.
Can suggest same in case stement if possible
Thank you Jim
so did you get an if statement to work
Previously i have written If statement , what i want to know case statement will work or not , But your correct .case statement will not work in this situation .
I have changed the other parameter to see the results and its working fine now .
Thanks for your time