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.
CustomerInfo
CustomerID Lastname Firstname Address City State ZipCode


PhoneNumbers
CustomerID PhoneNumber