• Sorry, The EMP table is not on a linked server, it is a SQL table in the Local database..

    does that explain the error ' ambiguous column name 'ext'