Properties

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

Columns

Name Data Type Length NULL IsGUID Description
  CustomerID  nchar  10       
  CompanyName  nvarchar  80       
  City  nvarchar  30       
  Country  nvarchar  30       
Total: 4 column(s)

Objects that [dbo].[Quarterly Orders] depends on

Object Name Owner Object Type Dep Level
  Customers  dbo  Table 
  Employees  dbo  Table 
  Shippers  dbo  Table 
  Orders  dbo  Table 
Total: 4 objects

SQL

create view "Quarterly Orders" AS
SELECT DISTINCT Customers.CustomerID, Customers.CompanyName, Customers.City, Customers.Country
FROM Customers RIGHT JOIN Orders ON Customers.CustomerID = Orders.CustomerID
WHERE Orders.OrderDate BETWEEN '19970101' And '19971231'

See Also

List of views