You want to populate the columns of an existing table with data from another table in the same database. Which of the following types of query should you use? code example

Example: insert to first table if field A equals field B from a second table using sql

UPDATE Table_1 SET Field_X = (SELECT Field_Y FROM Table_2 WHERE Table_1.Field_A=Table_2.Field_B LIMIT 1)