SQL copy data from to another table based on 2 matched column values

Asked Jun 22 '16 at 14:29

Active Nov 15 '20 at 23:54

Viewed 51 times

I have 2 tables, in same Database: table1 & table2.

table1 columns = a, b, c, d & table 2 columns = c, d, e, f

I am trying to UPDATE values a, b from e,f using:

UPDATE table1 as t1 
SET t1.a = t2.e, t1.b = t2.f
FROM table2 AS t2 
WHERE (t1.c=t2.c) AND (t1.d=t2.d);

Both matches are MUST. But its giving SQL Error. Any idea, what m doing wrong ?? Thanks in Advance.

edited Nov 15 '20 at 23:54

Dharman

asked Jun 22 '16 at 14:29

luna.romania

"But its giving SQL Error. " What error? – Oscar Jun 22 '16 at 14:31
What's the error it returns ? And can you please update the structure and data of your table. – Anand Jain Jun 22 '16 at 14:32
It simply says - SQL Syntax Error – luna.romania Jun 22 '16 at 14:33
@sgeddes Can u plz tell, where is its duplicate ?? – luna.romania Jun 22 '16 at 14:39
@Anandjain SQL Syntax near 'FROM table2 AS t2 WHERE (t1.c=t2.c) – luna.romania Jun 22 '16 at 14:41
@luna.romania -- you need to `join` the tables together as in the accepted answer. Your syntax is off for mysql. `update ... join ... set...` – sgeddes Jun 22 '16 at 14:41

0 Answers0