No se se dara resultado, pero intenta asi:
SELECT
ZERO_C2,
TUDO_C2,
FROM
TBLC1
LEFT JOIN
(SELECT KEY,C2 FROM TBLC2 WHERE C2 = 0)ZERO_C2
ON(MINC2.KEY = TBLC1.KEY)
LEFT JOIN
(SELECT KEY,MIN(C2) FROM TABELA WHERE C2 <> 0)TUDO_C2
ON(TUDO_C2.KEY = TBLC1.KEY)
|