Forum

oder gleich codieren:

SELECT
CASE
WHEN ( column1 = 1 AND column2 = 1 ) THEN ‘A’
WHEN ( column1 = 1 AND column2 = 0 ) THEN ‘B’
ELSE ‘C’
END

alternativ:

SELECT
CASE ( 10 * column1 + column2 )
WHEN 11 THEN ‘A’
WHEN 10 THEN ‘B’
ELSE ‘C’
END