|
Take Control: Q&A
Queries can also change the data.
How do you get the prices from the
rental table into the movie table? An Update query adds new
data to the records you already have.
Try it: Make an Update Query
Open the UpdateRecentMoviesSQ query
Switch to the Design View
Go to Design Ribbon
Select Update Query from the
list.
What Do You See?
Row three in the QBE grid says Update to.
|
|||
|
| |||
