Updating field from one table to another sql
27-Feb-2018 23:46
You can also include additional fields in the query grid to further limit the rows to be updated.
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.
Now run the qry Update Album Prices query found in the same database (see Figure 1-17).