SQL
USE [PrintMonitor]
GO
/****** Object:  View [dbo].[PAGES PRINTED BY PAPER TYPE]    Script Date: 10/15/2008 21:56:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[PAGES PRINTED BY PAPER TYPE]
AS
SELECT     TOP (100) PERCENT dbo.[Print Jobs].[User name], dbo.Printers.Name AS [Printer Name], dbo.[Print Jobs].[Paper Type], 
                      dbo.[Print Jobs].[Pages Printed]
FROM         dbo.[Print Jobs] INNER JOIN
                      dbo.Printers ON dbo.[Print Jobs].[Printer Id] = dbo.Printers.Id

Last edited Oct 15, 2008 at 8:56 PM by Merrion, version 1

Comments

No comments yet.