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)
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.