Posted by rdraider on 10/02/07 20:12

I have a strange issue and was hoping somebody could explain. The below
query gives an ambiquous column name error on an install of SQL 2005
Standard, sp2. This same query works fine on another install of SQL 2000
Standard sp4 and SQL 2005 Workgroup. The order by clause is causing the
error. I know this is easily fixed, just wondering why the error only
occurs on a particular install of SQL 2005.

SELECT DISTINCT ProcessName, ProcessName
FROM ProcessLog
ORDER BY ProcessName


Thanks.

[Back to original message]