Question about UPDATE data from another table in MySQL?

Question

MySQL

I have table1 with fields (A,B,C) and table2 with (D,B,C), A and D are rows
I want to update table1 like this (using phpMyAdmin)
UPDATE atm
SET
table1.B = table2. B
WHERE
table1.A=table2.D
When I run it, I get an error that, say, table2.B is an unknown column.
How to overcome it?
Thanks in advance.

Answer 1

Did you copy everything correctly? Table2.B does not appear in your query at all :)
Try this: UPDATE table1, table2 SET…