How to combine specific column values in an SQL statement
Posted
by Mehper C. Palavuzlar
on Stack Overflow
See other posts from Stack Overflow
or by Mehper C. Palavuzlar
Published on 2010-04-15T08:24:44Z
Indexed on
2010/04/15
8:33 UTC
Read the original article
Hit count: 360
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.
© Stack Overflow or respective owner
