Home Forums SQL Server 2005 T-SQL (SS2K5) Update Query - The table x is ambiguous RE: Update Query - The table x is ambiguous

  • April 8, 2013 at 1:17 am

    #1604292

    Shadab Shah (4/7/2013)

    Scott Thornton-407727 (11/9/2011)

    wow, that worked.

    I had no idea you could use Alias's in the UPDATE clause.

    Thanks!

    Hi experts,

    This solution is working for me as a butter on a hot pan. But I would like to know from you guys , when the alias works with an update why not the actual table name. I mean that if we use alias it works why not it works by specifying the table name.

    Using the table name works as long as YOU DO NOT alias it in the FROM part of the query - if you do, you need to reference the table using only this alias name.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.