How to update this sql query?

Question

I am trying to update the mysql table. But I am getting the error. Can you tell where is my query is going wrong?

Code:

UPDATE unlisted 
SET unlisted.cin_no = karnataka_cin.cin_no
WHERE unlisted.company_name = karnataka_cin.company_name;

Error:

1054 - Unknown column 'karnataka_cin.company_name' in 'where clause'

Answer 1

Here is an example of an UPDATE:

UPDATE unlisted u
  JOIN karnataka_cin k
    ON u.company_name = k.company_name
   SET u.cin_no = k.cin_no