Updating field from one table to another sql
You will be given questions that you need to solve.
After each exercise, we provide the solution so you can check your answer.
You can use update queries in Access to update the values in a target table, and you can use another table to supply the values for the update.
When the query is finished, open tbl Albums again—you should see that the Purchase Price field in this table has been updated based on the values in tbl Albums Updated (see Figure 1-18).
You say you are attempting to create a table, but show the code for updating rows within an existing table. If your intent is to insert rows from A B into C, you likely want to use an INSERT statement. @ypercube already gave a basic explanation in his comment.
UPDATE C SET column1 = A.column1 ,column2 = B.column2 ,column3 = A.column1 B.column2 FROM A JOIN B ON = -- ???
You can update more than one field at a time in an update query.
You can also include additional fields in the query grid to further limit the rows to be updated.