Home Forums SQL Server 2008 T-SQL (SS2K8) UPDATE SELECT RE: UPDATE SELECT

  • January 27, 2011 at 8:47 am

    #1279130

    UPDATE t2

    SET column1 = t1.column1, column2 = t1.column2,...

    FROM table1 t1 JOIN table2 t2

    ON t1.ID = t2.ID

    John