Posted by steve on 10/03/07 02:28

But why does this work?

SELECT CustomerID,CustomerID
FROM Orders

SELECT DISTINCT CustomerID,CustomerID
FROM Orders

This is what I was talking about in:

http://beyondsql.blogspot.com/2007/10/sql-two-standards-of-sql-cte.html

best,
steve
www.beyondsql.blogspot.com

[Back to original message]