Office中国论坛/Access中国论坛

标题: 一个很困惑的问题 [打印本页]

作者: dellxng 时间: 2011-7-22 16:29
标题: 一个很困惑的问题
请教各位高手.
我用MICROSOFT ACCESS写SQL。语句如下：

SELECT SHEET1.CONSIGNEE, SUM(SHEET1.TEU) AS TEU, SHEET1.TRADE, SHEET1.[P/C]
FROM (SELECT *
FROM SHEET1
WHERE SHEET1.[P/C] = 'C' and SHEET1.TRADE='AEX'
ORDER BY SHEET1.CONSIGNEE DESC)
GROUP BY SHEET1.CONSIGNEE, SHEET1.TRADE, SHEET1.[P/C]
ORDER BY SUM(SHEET1.TEU) DESC;

第一次编译ok，但是，第二次就不行了，总是出现错误提示，如下：
Invalid bracketing of name'SELECT *
FROM SHEET1
WHERE SHEET1.[P/C'

我查了一下语句，发现，系统自动加了些东西，如下：
SELECT SHEET1.CONSIGNEE, SUM(SHEET1.TEU) AS TEU, SHEET1.TRADE, SHEET1.[P/C]
FROM [SELECT *
FROM SHEET1
WHERE SHEET1.[P/C] = 'C' and SHEET1.TRADE='AEX'
ORDER BY SHEET1.CONSIGNEE DESC]. AS [%$##@_Alias]GROUP BY SHEET1.CONSIGNEE, SHEET1.TRADE, SHEET1.[P/C]
ORDER BY SUM(SHEET1.TEU) DESC;

现在只能每次用的时候重新贴一遍原语句。太麻烦了。
请教高手，这个问题如何解决

作者: zhuyiwen 时间: 2011-7-22 19:20

SELECT s.CONSIGNEE, SUM(s.TEU) AS TEU, s.TRADE, s.[P/C]
FROM (
SELECT *
FROM SHEET1
WHERE [P/C] = 'C' and TRADE='AEX'
ORDER BY CONSIGNEE DESC
) s
GROUP BY s.CONSIGNEE, s.TRADE, s.[P/C]
ORDER BY SUM(s.TEU) DESC;

复制代码

作者: 蓝翔 时间: 2011-8-27 13:30
这个我也很困惑

Signature----------------------------------------------Wise man have their mouths in their hearts, fools have their hearts in their mouthsnike free run 2 womens nike free run nike free run womens

欢迎光临 Office中国论坛/Access中国论坛 (http://www.office-cn.net/)