sql - MS-Access - 您试图在 JOIN 中执行查询语法错误

Question

请帮忙，我看不出我做错了什么。但我有 2 个分组

SELECT DISTINCT 
    SalesmanTable.SalesNum,
    (SalesmanTable.SalesFName & ' ' & SalesmanTable.SalesLName),
    BusinessInfo.BusinessNum,
    BusinessInfo.BusinessName,
    BusinessInfo.OwnerName 
FROM
    ((SalesmanTable 
LEFT JOIN 
    OrderInfo ON SalesmanTable.[SalesNum] = OrderInfo.[SalesNum]) 
LEFT JOIN 
    BusinessInfo ON OrderInfo.[BusinessNum] = BusinessInfo.[BusinessNum] 
WHERE
    OrderInfo.Paid = FALSE 
GROUP BY 
    SalesmanTable.SalesNum, BusinessInfo.BusinessNum 
GROUP BY 
    SalesmanTable.SalesNum, 
    (SalesmanTable.SalesFName & ' ' & SalesmanTable.SalesLName), 
    BusinessInfo.BusinessNum, BusinessInfo.BusinessName, BusinessInfo.OwnerName;

标签： sqlms-access

Answer 1

这是你的FROM条款：

FROM ((SalesmanTable LEFT JOIN
       OrderInfo
       ON SalesmanTable.[SalesNum] = OrderInfo.[SalesNum]
      ) LEFT JOIN
      BusinessInfo
      ON OrderInfo.[BusinessNum] = BusinessInfo.[BusinessNum]

括号不平衡。所以：

FROM (SalesmanTable LEFT JOIN
      OrderInfo
      ON SalesmanTable.[SalesNum] = OrderInfo.[SalesNum]
     ) LEFT JOIN
     BusinessInfo
     ON OrderInfo.[BusinessNum] = BusinessInfo.[BusinessNum]