Fórum Nao trazer linha de subselect quando resultados dos dois forem igual a 0 #503393

Eu não sei se no oracle funciona, mas eu colocaria um select por fora mais ou menos assim:

Select * from
(
select FUN.NUMCAD, FUN.NOMFUN,
(SELECT
COUNT (AFA.DATAFA)
FROM R038AFA AFA
WHERE AFA.NUMEMP = FUN.NUMEMP
AND AFA.TIPCOL = FUN.TIPCOL
AND AFA.NUMCAD = FUN.NUMCAD
AND AFA.DATAFA >='01-JAN-2014'
AND AFA.DATTER <='31-JAN-2014'
AND AFA.SITAFA IN (15,900)) JANEIRO_2014,
(SELECT
COUNT (AFA.DATAFA)
FROM R038AFA AFA
WHERE AFA.NUMEMP = FUN.NUMEMP
AND AFA.TIPCOL = FUN.TIPCOL
AND AFA.NUMCAD = FUN.NUMCAD
AND AFA.DATAFA >='01-FEV-2014'
AND AFA.DATTER <='28-FEV-2014'
AND AFA.SITAFA IN (15,900)) FEVEREIRO_2014

from R034FUN FUN
WHERE FUN.NUMEMP = 7
AND FUN.TIPCOL = 1
AND FUN.SITAFA <> 7;
)
where
(JANEIRO_2014 <> 0) and
(FEVEREIRO_2014 <> 0)