You can't update multiple tables in one statement
UPDATE Table1 , Table2 SET Table1 . LastName = 'DR. XXXXXX' , Table2 . WAprrs = 'start,stop' FROM Table1 T1 , Table2 T2 WHERE T1 . id = T2 . id and T1 . id = '010008' You can't update multiple tables in one statement, however, you can use a transaction to make sure that two UPDATE statements are treated atomically. You can also batch them to avoid a round trip. BEGIN TRANSACTION ; UPDATE Table1 SET Table1 . LastName = 'DR. XXXXXX' FROM Table1 T1 , Table2 T2 WHERE T1 . id = T2 . id and T1 . id = '011008' ; UPDATE Table2 SET Table2 . WAprrs = 'start,stop' FROM Table1 T1 , Table2 T2 WHERE T1 . id = T2 . id and T1 . id = '011008' ; COMMIT ; you can't update two tables at once, but you can link an update into an insert using OUTPUT INTO, and you can use this output as a join for the second update: DECLARE @ ids TABLE ( id int ); BEGIN TRANSACTION UPDATE Table1 S...