Home Forums SQL Server 2005 SQL Server 2005 General Discussion Update one column of a table with data from another table RE: Update one column of a table with data from another table

  • July 27, 2008 at 6:13 am

    #848891

    UPDATE A

    SET A.LocationCode = B.LocationCode

    FROM tableA A INNER JOIN tableB B ON A.id = B.id

    --Ramesh