Untitled

 avatar
user_3268554
plain_text
a month ago
289 B
2
Indexable
Never
SELECT c.nombre AS nombre_cliente, c.apellido AS apellido_cliente, v.nombre AS nombre_vendedor, v.apellido AS apellido_vendedor
FROM clientes c
JOIN ventas ve ON c.id = ve.id_cliente
JOIN vendedores v ON ve.id_vendedor = v.id
WHERE c.direccion = 'Cubas'
ORDER BY v.apellido, v.nombre;
Leave a Comment