Properties

Owner:	dbo
Schema bound:
Encrypted:
Creation Date:	08/06/2000
Description:

Columns

	Name	Data Type	Length	NULL	IsGUID	Description
	City	nvarchar	30
	CompanyName	nvarchar	80
	ContactName	nvarchar	60
	Relationship	varchar	9

Total: 4 column(s)

Objects that [dbo].[Customer and Suppliers by City] depends on

	Object Name	Owner	Object Type	Dep Level
	Customers	dbo	Table	1
	Suppliers	dbo	Table	1

Total: 2 objects

SQL

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

See Also

List of views