Funzione count() in Join

[piero.mac]

SELECT campoA, (select count(*) from tabella
                        where tipo_campo = 2) as TotaleCampiNum
FROM tabella
where campoA = 'abcdef'

.