mysql - 对于这个 MySQL 查询有更好的方法吗？

Question

以下查询查找所有商店的董事。我认为有一个更简单的解决方案，我更喜欢使用它。谢谢。

SELECT s.ShopID, (EmployeeName+' '+EmployeeSurname) AS FullName FROM shop AS s
JOIN WorksOn AS w ON s.ShopID = w.ShopID
JOIN employee AS e ON w.EmployeeID = e.EmployeeID
JOIN director AS d ON e.EmployeeID = d.EmployeeID

表格

employee : EmployeeID, EmployeeName,EmployeeSurname
shop: ShopID, Name, Address
WorksOn: EmployeeID, ShopID
director: EmployeeID

Answer 1

这是一个非常简单的查询。根据您提供的信息，我没有看到任何更简单的事情。

请原谅。是的，您可以通过 2 个连接来完成:

SELECT 
    w.ShopID, (EmployeeName+' '+EmployeeSurname) AS FullName 
FROM 
    WorksOn AS w
    JOIN employee AS e ON w.EmployeeID = e.EmployeeID
    JOIN director AS d ON e.EmployeeID = d.EmployeeID