mysql - SQL 查询 - JOIN 和 UNION

Question

我很难回答这个问题:显示为巴黎客户进行销售的员工的姓氏和客户公司(公司)”，按公司名称排序。

这是我的代码:

select NAME from EMPLOYEES inner join SALES on EMPLOYEES.NO_EMPLOYEES = SALE.NO_EMPLOYEES
union
select COMPANY from SALES inner join CLIENTS on SALES.CODE_CLIENT = CLIENTS.CODE_CLIENT where CLIENTS.CITY = 'Paris'

问题是 union 只给了我一列...如何解决这个问题？

感谢您的帮助!

Answer 1

我认为你只想要两个连接:

select e.NAME, c.COMPANY
from EMPLOYEES e join
     SALES s
     on e.NO_EMPLOYEES = s.NO_EMPLOYEES join
     CLIENTS c
     on s.CODE_CLIENT = c.CODE_CLIENT
where c.CITY = 'Paris';