There are two variables in our database called OB
and B2B_OB
. There are EP codes and each EP may have one of the following 4 combinations:
EP OB B2B_OB
--- -- ------
3 X
7 X
11
14 X X
What I want to do is to combine the X's in the fetched list so that I can have A or B value for a single EP. My conditions are:
IF (OB IS NULL AND B2B_OB IS NULL) THEN TYPE = A
IF (OB IS NOT NULL OR B2B_OB IS NOT NULL) THEN TYPE = B
The list I want to fetch is like this one:
EP TYPE
--- ----
3 B
7 B
11 A
14 B
How can I do this in my query? TIA.