Rails 表查询的“缺少表的 FROM 子句条目”错误[关闭]

我正在尝试使用inner join使用以下查询的视图和表

SELECT 
   AcId, AcName, PldepPer, RepId, CustCatg, HardCode, BlockCust, CrPeriod, CrLimit, 
   BillLimit, Mode, PNotes, gtab82.memno 
FROM
   VCustomer 
INNER JOIN   
   vcustomer AS v1 ON gtab82.memacid = v1.acid 
WHERE (AcGrCode = '204' OR CreDebt = 'True') 
AND Masked = 'false'
ORDER BY AcName

错误是

missing FROM-clause entry for table "gtab82"

SELECT 
   AcId, AcName, PldepPer, RepId, CustCatg, HardCode, BlockCust, CrPeriod, CrLimit, 
   BillLimit, Mode, PNotes, gtab82.memno 
FROM
   VCustomer AS v1
INNER JOIN   
   gtab82 ON gtab82.memacid = v1.AcId 
WHERE (AcGrCode = '204' OR CreDebt = 'True') 
AND Masked = 'false'
ORDER BY AcName

通常，仅当由于联接表中的列名重复并且表名很长或当表与其自身联接时，需要为列添加表名前缀时，才对表名使用别名。在您的情况下，您使用别名VCustomer但仅在ON出于不确定原因的条款。您可能需要检查代码的这方面。