Me respondo, la solución es:
SELECT PROVEEDORES.rut, Sum(COMPRA.total) AS TOTAL_ANUAL, COUNT(COMPRA.FACTURA) AS TOTAL_FACTURAS, Sum(
Switch(COMPRA.TIPO='X',1)) AS TOTAL_VALOR_X, Count(
Switch(COMPRA.TIPO='Y',1)) AS TOTA_VALOR_Y FROM PROVEEDORES INNER JOIN COMPRA ON PROVEEDORES.Rut = COMPRA.Rut WHERE (((COMPRA.AÑO)=2006))
GROUP BY PROVEEDORES.rut;
Saludos
Extraido de:
http://office.microsoft.com/es-es/ac...CH100728913082