RelationalDBDesign
SiteMap
Advanced SQL
Essential SQL
Interview Questions
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
Submit
x