SQL Views   «Prev 

Create View that joins Two Tables

Create a view that joins two tables.
Given the following two tables, create a view that will join them, based on CustomerID, and present them as if they were a single table.
CustomerID Lastname Firstname Address City State ZipCode

CustomerID PhoneNumber