Are now moving to sqlserver from sybase and are testing new applications with the database, but it has created a problem: many of the queries that are running are generating the error Ambiguous column name are dozens of screens that are presenting this problem not occurred in sybase. Is there some command to make consistent sybase queries that generated no problem?.

The queries are in each form and invoked with SQLEXEC ()

Sample :

work fine in Sybase but not in sqlserver

select DESC_PROF,CODI_PROF,DESC_PROF from PROF order by DESC_PROF

thank you very much for your help.