Query SELECT e.nombre AS nom_emple, c.nombre AS nom_cli, SUM(v.importe) AS total FROM empresa.ventas v JOIN empresa.clientes c ON v.cliente=c.id LEFT JOIN empresa.empleados e ON e.id=v.vendedor GROUP BY v.cliente,v.vendedor HAVING total>200, Sun Nov 23 20:45:54 2008