Prueba esta consulta:
Código sql:
Ver originalSELECT idvendedor, COUNT( datavenda ) AS atendimientos, t1.adicionaisofertados2
FROM tb_venda
INNER JOIN (
SELECT idvendedor AS clave2, COUNT( datavenda ) AS adicionaisofertados2
FROM tb_venda
WHERE DATE( tb_venda.datavenda )
BETWEEN '2007-01-01'
AND '2009-10-31'
AND tb_venda.adicionaisofertados = '1'
GROUP BY idvendedor
)t1 ON tb_venda.idvendedor = t1.clave2
WHERE DATE( tb_venda.datavenda )
BETWEEN '2007-01-01'
AND '2009-10-31'
GROUP BY idvendedor