[RESOLVIDO]Ajuda com Query

[burgaParticipante]

Tente filtrar com a cláusula HAVING ao invés de usar WHERE:

SELECT DISTINCT CODCOLIGADA, MAX(MESCOMP), MAX(ANOCOMP)
FROM PFPERFF
GROUP BY CODCOLIGADA
HAVING MAX(ANOCOMP) <= '2010'
ORDER BY CODCOLIGADA

Abraços,