Answers for "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?"

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)

Posted by: Guest on June-23-2020

Code answers related to "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?"