How to correctly access a table field in a database?

Question

MySQL

UPDATE Test SET second_name = Second_name.id WHERE Test.second_name = second_name.Second_name;

I have a database update request but it fails, an error occurs

Unknown column 'second_name.Second_name' in 'where clause'

While the second_name field exists in the second_name table.
How can this be fixed?

Answer 1

If I understood the query correctly, then you are trying to put a value from another table. Then the question is, why don't you join with the Second_name table by condition in the where clause?