Link to home
Start Free TrialLog in
Avatar of sam2929
sam2929

asked on

case stmt logic

HI,
I Have three columns

Table a

009 Z03 Z09
1    1       4
2
3    2       6
4    5      7

Then TABLE B
Id   KEY
1      001
2      002
5    0050
6    0060

I Want to join A with B so that if table  id don’t match table A column 009 then match against Z03 else Z09

So results should be

009     Z03    Z09     key
1            1       4        001
2                               002
3            10       6      0060 ( In this case id =Z09)
4               5      7       0050 ( In this case id =Z03)
ASKER CERTIFIED SOLUTION
Avatar of Member_2_2484401
Member_2_2484401
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial