Update Query with INNER JOIN between tables in 2 different databases on 1 server

Worked perfectly for me.

UPDATE TABLE_A a INNER JOIN TABLE_B b ON a.col1 = b.col2 SET a.col_which_you_want_update = b.col_from_which_you_update;

It is very simple to update using Inner join query in SQL .You can do it **without** *using* `FROM` clause. Here is an example :

UPDATE customer_table c

INNER JOIN
employee_table e
ON (c.city_id = e.city_id)

SET c.active = "Yes"

WHERE c.city = "New york";