Query SELECT e.nombre AS nom_emple, c.nombre AS nom_cli, SUM(v.importe) AS total_vendido FROM empresa.ventas v JOIN empresa.clientes c ON c.id=v.cliente LEFT JOIN empresa.empleados e ON e.id=v.vendedor GROUP BY v.cliente,v.vendedor, Sun Nov 23 19:44:33 2008