一个很困惑的问题

dellxng

请教各位高手.
我用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

1. 
   
2. SELECT s.CONSIGNEE, SUM(s.TEU) AS TEU, s.TRADE, s.[P/C]
   
3. FROM (
   
4.     SELECT *   
   
5.     FROM SHEET1
   
6.     WHERE [P/C] = 'C' and TRADE='AEX'
   
7.     ORDER BY CONSIGNEE DESC
   
8. ) s
   
9. GROUP BY s.CONSIGNEE, s.TRADE, s.[P/C]
   
10. ORDER BY SUM(s.TEU) DESC;
    

复制代码

蓝翔

这个我也很困惑

















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