Northwind

Basic Index   Expanded Index

View Name:Customer and Suppliers by City

FieldTypeNulls?
Citynvarchar (15)Yes
CompanyNamenvarchar (40)No
ContactNamenvarchar (30)Yes
Relationshipvarchar (9)No

create view "Customer and Suppliers by City" AS
SELECT City, CompanyName, ContactName, 'Customers' AS Relationship
FROM Customers
UNION SELECT City, CompanyName, ContactName, 'Suppliers'
FROM Suppliers
--ORDER BY City, CompanyName