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