sql - 与 MS-ACCESS 中的布尔字段聚合时出现“无当前记录”错误

Question

此查询返回“无当前记录”错误。[use_Override1] 是布尔值。相反，如果我将 [use_Override1] 定义为值为“TRUE”或“FALSE”的字符串，它会起作用。有人可以告诉我为什么吗？

SELECT  '*' AS Sector, tbl.blkName AS Sector2, Sub2.use_Override1
FROM( (dbSecurityAllocation AS tbl 
LEFT JOIN 
(SELECT * FROM dbHoldings WHERE dbHoldings.Code_BB='SQECR' AND DataDiEstrazione='30/11/2020') AS Sub1 
ON tbl.isin=Sub1.isin) 
LEFT JOIN  
(SELECT * FROM dbAggregateAlloc WHERE Code_BB='SQECR' AND fldName='FUND_ASSET_ALLOC_CALC')  AS Sub2 
ON Sub2.blkName=tbl.blkName)
GROUP BY  tbl.blkName,Sub2.use_Override1

标签： sqlms-accessms-access-2010