Query SELECT c.nombre AS nom_cli,e.nombre AS nom_emple, v.importe FROM empresa.ventas v JOIN empresa.clientes c ON c.id=v.cliente LEFT JOIN empresa.empleados e ON e.id=v.vendedor, Sun Nov 23 19:24:39 2008
| nom_cli | nom_emple | importe |
| Matt Design | Carlos Zaltzman | 178.50 |
| Diana P‚rez | Carlos Zaltzman | 195.00 |
| John Smith | Carlos Zaltzman | 178.50 |
| Matt Design | Carlos Zaltzman | 16.00 |
| Matt Design | Juan Fern ndez | 220.00 |
| Matt Design | Carlos Zaltzman | 5.50 |
| Matt Design | Juan Fern ndez | 11.00 |
| Matt Design | Juan Fern ndez | 5.50 |
| Diana P‚rez | Carlos Zaltzman | 200.00 |