query com group by e subselect

Question

No oracle n�o tem geito de funcionar o group by...
Como resolver????
Obrigado!

SELECT C11 AS r1,
c12 AS r2,
(SELECT C22 FROM tabela2
WHERE c12 = c21) AS r3,
COUNT(*)
FROM table1
GROUP BY 1,2,3
ORDER BY 1,2,3;

Emerson Nascimento · Answer

tente assim:[code:1:d99c035379]SELECT  t1.C11 AS r1,  t1.C12 AS r2,  t2.C22 AS r3,  COUNT(*)FROM  table1 t1LEFT JOIN  tabela2 t2 on (t2.c21 = t1.c12)GROUP BY  t1.C11,  t1.C12,  t2.C22ORDER BY  t1.C11,  t1.C12,  t2.C22[/code:1:d99c035379]...

F�rum query com group by e subselect #364556