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