Loading Consent Dialog
SQL Views   «Prev 

Create and Update SQL View - Exercise

Objective: Create a view, then create the UPDATE statement to modify the values in the view.
Given the following two tables, first create a view that is updateable, then create the UPDATE statement that will update the customer last name and the phone number in your view.
Customers
CustomerID Lastname Firstname Address City State ZipCode

PhoneNumbers

CustomerID PhoneNumber