Problema con consulta Left Join

[quimfv]

Y esto?...

Código sql:

SELECT A.id, A.aviso, SbC.postulantes AS TOTAL
FROM A LEFT JOIN (SELECT B.posting_id, COUNT(*) AS postulantes
                                     FROM B
                                      GROUP BY B.posting_id) AS SbC
ON A.id = SbC.posting_id
 

en la sentencia de gnzsoloyo cambiaria

GROUP BY A.id, A.aviso


creo...


Quim