how to join 2 table and update column the both together

Question

table 1 :

idtb1 --pk
published
delete

table 2 :

idtb2 --pk
idtb1 --fk
published
delete

how to update 2 column published ,delete on 2 table together by command Update

You mean with one update statement? – Andy Wiesendanger Mar 22 '16 at 14:57 — Andy Wiesendanger, Mar 22 '16 at 14:57
@AndyWiesendanger : yup!, ^^! – avkkamsy Mar 22 '16 at 15:29 — avkkamsy, Mar 22 '16 at 15:29
@avkkamsy Did you try my solution? – sagi Mar 22 '16 at 15:46 — sagi, Mar 22 '16 at 15:46

score 4 · Accepted Answer · edited May 23 '17 at 12:16

4

You can't update more than one table in a single statement

       BEGIN TRANSACTION

       update A
       set A.published =  @published
       from table1 A 
       inner join table2 B on B.idtb1 = A.idtb1

      update B
      set B.published = @published 
      from table2 B 
      inner join table1 A on B.idtb1 = A.idtb1

      COMMIT

This question already has an answer here

edited May 23 '17 at 12:16

Community

1
1

answered Mar 22 '16 at 16:34

Jande

1,695
2
20
32

how to join 2 table and update column the both together

1 Answers1