Question: Database Processing (14th edition); M Kroenke, David M and Seaman, Don F; Chapter 7 7.38 Write an SQL statement to create a view named Customer01DataView




Database Processing (14th edition); M Kroenke, David M and Seaman, Don F; Chapter 7 7.38 Write an SQL statement to create a view named Customer01DataView based on the CUSTOMER 01 table. In the view, include the values of EmailAddress, LastName as CustomerLastName, and FirstName as CustomerFirstName. Run this statement to create the view. and then test the view by writing and running an appropriate SQL SELECT statement
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
