缺少表的FROM子句条目[关闭]

Question

我正在尝试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"

Answer 1

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出于不确定的原因仅在子句中使用它。您可能需要查看代码的这一方面。