Quelque chose dans ce goût là :

SELECT A, B, C, CASE WHEN C3 THEN D END as D
FROM T2
WHERE C1 AND C3
UNION ALL
SELECT A, B, C, CASE WHEN C3 THEN D END as D
FROM T2
WHERE C2 AND C3