Access 97节SQL SERVER 2005 [英] Access 97 verses SQL SERVER 2005

问题描述

我从Access 97和SQL SERVER 2005都运行了这个简单的代码.在Access中，我收到了12285条记录，在SQL Server中，我收到了17115条记录.我在那里有人知道这个简单代码有什么问题吗???还是您有什么想法?

I ran this simple code from both Access 97 and SQL SERVER 2005. In Access I received 12285 records and in SQL Server I received 17115 records. I s there anyone That knows what is wrong with this simple code??? Or do you have any ideas?

SELECT A.CUS_NUM_AR,A.INS_CO_AR,A.APPLY_TO_AR,AT.AttributeID,<br />
<br />
SUM(A.TOTALAMOUNT) AS ''Total Amount''<br />
FROM AR700.dbo.tblAROPEN A<br />
<br />
INNER JOIN LMSDATA.dbo.tblCustomerAttribute AT<br />
<br />
ON A.CUS_NUM_AR = AT.CustomerNumber<br />
<br />
WHERE A.INS_CO_AR IN (''0'',''000'')<br />
<br />
AND AT.AttributeID = 3  <br />
AND A.TOTALAMOUNT >0 <br />
<br />
GROUP BY A.CUS_NUM_AR,A.INS_CO_AR,A.APPLY_TO_AR,AT.AttributeID<br />
<br />
ORDER BY A.CUS_NUM_AR

推荐答案

Try

Try

SELECT 
   A.CUS_NUM_AR,
   A.INS_CO_AR,
   A.APPLY_TO_AR,
   AT.AttributeID,
   SUM(A.TOTALAMOUNT) AS ''Total Amount''
 FROM AR700.dbo.tblAROPEN A
 INNER JOIN LMSDATA.dbo.tblCustomerAttribute AT
   ON (A.CUS_NUM_AR = AT.CustomerNumber AND AT.AttributeID = 3)
 WHERE 
   A.INS_CO_AR IN (''0'',''000'')
 AND 
   A.TOTALAMOUNT >0
 GROUP BY A.CUS_NUM_AR,A.INS_CO_AR,A.APPLY_TO_AR,AT.AttributeID
 ORDER BY A.CUS_NUM_AR

我只是在JOIN上加上了括号，并不是说它会有所帮助

我可以肯定我不会信任Access 97 ...
错误:对记录进行排序时，记录会消失 [

I just added parenthesis on the JOIN, not that I think it will help

I''m fairly certain I wouldn''t trust Access 97 for anything ...
Bug: Records disappear when you sort them[^]

Best regards
Espen Harlinn

这篇关于Access 97节SQL SERVER 2005的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！