高手来找错，高分！！

2003-01-01 09:00:10 136 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

CSP-J/S复试高分秘诀经验分享这篇文章是今年3月份参加NOI Online测试之前和老码农一起整理的一份资料，分享给备战今年10月份复赛的OIer，还有不到4个月，还有很多不会的知识点，没有退路，唯有努力坚持前行。阅读数据规模，分析样例数据分布：重要、重要、重要条件分支：草稿纸确认算法遇到熟悉的题目要十分警惕，先在草稿纸上演算计算步骤，并测试其正确性编写代码前要有充足思考时间，最好举例子通过草稿纸验证 -> 尽量不要边写边改程序名和输入输出文件编程：保持思路清晰，参照样例数据分布和条件分支，尽量一次把程序编好检查程序：静态检查 -> 动阅读详情

现有如下SQL语句：
SELECT A.PDT_ID,A.PDT_NAME,B.quan AS 数量, B.pri AS 单价, B.cn AS 金额,C.quan as 数量1,C.pri as 单价1,C.cn as 金额1
FROM PDT_TABLE AS A
LEFT JOIN
(
SELECT PDT_ID, sum(quantity) AS quan, sum(cnt)/sum(quantity) AS pri, sum(cnt) AS cn
FROM XSFP_TABLE GROUP BY pdt_id
)
AS B
ON A.pdt_id=B.pdt_id
LEFT JOIN
(
SELECT PDT_ID, sum(quantity) AS quan, sum(cnt)/sum(quantity) AS pri, sum(cnt) AS cn
FROM XSFP_TABLE
WHERE crea_date>#10/1/2002# And crea_date<#10/31/2002#
GROUP BY pdt_id
)
AS C
ON A.pdt_id = C.pdt_id
提示的错误是：
A.pdt_id=B.pdt_id
LEFT JOIN
(
SELECT PDT_ID, sum(quantity) AS quan, sum(cnt)/sum(quantity) AS pri, sum(cnt) AS cn
FROM XSFP_TABLE
WHERE crea_date>#10/1/2002# And crea_date<#10/31/2002#
GROUP BY pdt_id
)
AS C
ON A.pdt_id = C.pdt_id
这部分“操作符丢失”，偶百思不得其解，希望各位达人指点迷津
PS：
1。偶用的是ACCESS
2。把最后一句改成ON B.pdt_id = C.pdt_id也不行，提示还是“操作符丢失”

...全文