• 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.