Problem:
Resolution:
SELECTNOME,DECODE(COUNT(CODIGO_LIVRO),0,'NENHUM',COUNT(CODIGO_LIVRO))"NR LIVROS"
FROM AUTORES A,LIVROS L
WHERE A.CODIGO_AUTOR=L.CODIGO_AUTOR(+)
GROUP BY NOME
ORDER BY 1;
Tables:
You can not reply to this topic
Why do I need the second COUNT(CODIGO_LIVRO)
within the function DECODE
and what does (+) mean? If I'm not mistaken, (+) is a join but I do not understand how it works and why it's needed there ...