我正在尝试将以下SQLite
查询转换为MS-ACCESS
(Microsoft Access 2016)查询,但没有成功:SQLite
中的查询:
SELECT c.CategoryName, s.SubCategoryName, COUNT(l.LoanDate) AS Count
FROM LoanCategories c CROSS JOIN LoanSubCategories s
LEFT JOIN Loans l
ON l.LoanCatId = c.CategoryId AND l.LoanSubCatId = s.CategoryId AND l.LoanDate = '19990125'
GROUP BY c.CategoryName, s.CategoryName;
我在MS-ACCESS
中尝试了以下查询,导致了'Syntax error in JOIN operation'错误:
我在MS-ACCESS
中的查询:
SELECT c.CategoryName, s.SubCategoryName, COUNT(l.LoanDate) AS Count
FROM LoanCategories c, LoanSubCategories s
LEFT JOIN Loans l
ON l.LoanCatId = c.CategoryId AND l.LoanSubCatId = s.CategoryId AND l.LoanDate = '19990125'
GROUP BY c.CategoryName, s.CategoryName;
如何在MS-ACCESS
中重写查询?
1条答案
按热度按时间k97glaaz1#
MS-Access中的语法完全不同。
不支持显式的
CROSS
连接,您必须使用旧的逗号语法。此外,联接的
ON
子句不能包含像LoanDate = '19990125'
这样的表达式。查询可以这样写: