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

• Next in forum: Re: SQL Configuration - RAM
• Prev in forum: Re: Finding common joins
• Thread view: Re: SQL 2005 Ambiguous column name

[Reply to this message]