>>If only one table is used in a query, why do you need to use table's name referring to its columns?
>>
>>Also, could it be case-sensitive installation of SQL Server?
>
>:-)
>This is an example, not the full query.
>No, nothing on this server is case or accent sensitive.
For multi-table queries I normally use aliases so never faced this problem.
If it's not broken, fix it until it is.
My Blog