Query SELECT c.nombre AS nom_cli, e.nombre AS nom_emple, v.importe, a.nombre FROM empresa.ventas v JOIN empresa.clientes c ON v.cliente=c.id LEFT JOIN empresa.empleados e ON v.vendedor=e.id JOIN empresa.articulos a ON v.articulo=a.id, Sun Nov 23 20:52:52 2008
| nom_cli | nom_emple | importe | nombre |
| Matt Design | Carlos Zaltzman | 178.50 | Monitor 16" |
| Diana P‚rez | Carlos Zaltzman | 195.00 | Monitor 20" |
| John Smith | Carlos Zaltzman | 178.50 | Monitor 16" |
| Matt Design | Carlos Zaltzman | 16.00 | Diskettes 20 |
| Matt Design | Juan Fern ndez | 220.00 | Monitor 22" |
| Matt Design | Carlos Zaltzman | 5.50 | Papel A4-500 |
| Matt Design | Juan Fern ndez | 11.00 | Papel A4-500 |
| Matt Design | Juan Fern ndez | 5.50 | Papel A4-500 |
| Diana P‚rez | Carlos Zaltzman | 200.00 | Monitor 20" |