Is there any way—short of using a complex VBA procedure—to update the price data in the existing table based on the updated prices from the imported table without overwriting any of the other fields in the existing table?
You can use this method to update multiple records, but you still need to step through each record and click on the field to update the record.
This can be cumbersome if you have multiple records.
To do this, we can use a subquery in the SET clause.
We could use separate statements, but it’s easier to maintain using a single statement.
Here are the steps to create an update query that updates values across tables: database.
Note that most of the purchase prices are null (see Figure 1-15).
You can also insert data using the 'traditional' method you'd use when using a command line or SQL Plus.
Return to the SQL Worksheet and enter the command: Insert into departments (DEPARTMENT_ID, DEPARTMENT_NAME) Values (300, 'Research'); Click F9.
We can continue working with our example from the previous steps.
Assume that the company wants to activate products that have a price above average.
Our statement would look like this: You can see that the SET clause includes a subquery, which finds the MAX value of the price column in the product table and multiplies it by 1.2 to add 20%.