Need to update records between tables with matching values

Asked Nov 02 '17 at 20:55

Active Nov 02 '17 at 20:58

Viewed 46 times

I need to update a column table from another table where there are maching value between corresponding records. I have the following statement but I need help with the syntax.

 UPDATE table_a
    SET field_1 = table_b.field_1
    WHERE table_a.field_2=table_b.field_2
      AND table_a.field_3=table_b.field_3 
      AND table_a.field_4=table_b.field_4
      AND table_a.field_5=table_b.field_5

asked Nov 02 '17 at 20:55

Pier67

@shadow how can you close a question with two answer? – Juan Carlos Oropeza Nov 02 '17 at 20:59
@JuanCarlosOropeza you can edit the list of duplicate questions after hammering with a single one. – Shadow Nov 02 '17 at 21:00

Need to update records between tables with matching values

0 Answers0