Office中国论坛/Access中国论坛

标题: 这句SQL语句我不太懂,为什么是>=呢? [打印本页]

作者: xls901    时间: 2002-11-9 17:19
标题: 这句SQL语句我不太懂,为什么是>=呢?
SELECT Customers.CustomerID, Count(Customers_1.CustomerId) AS [Counter]
FROM Customers INNER JOIN Customers AS Customers_1 ON Customers.CustomerId>=Customers_1.CustomerId
GROUP BY Customers.CustomerId
ORDER BY Customers.CustomerId;
[em26]
作者: INN    时间: 2002-11-21 05:00
把>=改为 = ,< 或 <=运行一下看有什么结果就知到了.




欢迎光临 Office中国论坛/Access中国论坛 (http://www.office-cn.net/) Powered by Discuz! X3.3