业务员计划视图.sql

来自「用delphi+intraweb写的简单报表系统（activeform使用技术）」· SQL 代码 · 共 8 行

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[xxv_PersonPlan]')   and OBJECTPROPERTY(id, N'IsView') = 1)
DROP VIEW xxv_PersonPlan
GO

 CREATE VIEW dbo.xxv_PersonPlan AS  
SELECT PP.cPersonID AS 业务员号, P.cPersonName AS 业务员, PP.iMonth AS 月份,    PP.fMoney AS 月计划  
FROM dbo.xxPersonPlan PP LEFT OUTER JOIN    dbo.Person P ON P.cPersonCode = PP.cPersonID