System.Data.OleDb.OleDbException - sql 中的语法错误

我在这个 SQL 中有一个语法错误：

string sSql = $"SELECT OxygenTankInDetailTBL.HBedNameID, 
                       OxygenTankInDetailTBL.LocationHB 
                FROM OxygenTankInDetailTBL 
                INNER JOIN SectionsNameTBL ON (SectionsNameTBL.SectionID = OxygenTankInDetailTBL.LocationHB 
                                           AND SectionsNameTBL.LocationG = '{locationG}') 
                INNER JOIN OxygenTankTBL ON (OxygenTankTBL.HBedID = OxygenTankInDetailTBL.HBedNameID 
                                         AND OxygenTankTBL.IsActive= {true});"; 

错误是：

System.Data.OleDb.OleDbException：“查询表达式中存在语法错误（缺少运算符）”(SectionsNameTBL.SectionID = OxygenTankInDetailTBL.LocationHB AND SectionsNameTBL.LocationG = 'agaf1') INNER JOIN OxygenTankTBL ON(OxygenTankTBL.HBedID = OxygenTankInDetailTBL.HBedNameID AND 氧气罐TBL .IsActive= True'.'

Thanks

如果您的 DBMS 是 MS Access，请参阅此示例。
我猜，你可以在 JOIN 操作中 JOIN 1 个表或子查询。将附加连接包装在子查询中。

SELECT *
FROM SectionsNameTBL 
RIGHT JOIN (
       OxygenTankTBL RIGHT JOIN OxygenTankInDetailTBL 
        ON OxygenTankTBL.HBedID = OxygenTankInDetailTBL.HBedNameID
   ) 
  ON SectionsNameTBL.SectionID = OxygenTankInDetailTBL.LocationHB
WHERE SectionsNameTBL.LocationG = 'agaf1'
  AND OxygenTankTBL.IsActive= true
;