GoldHoo/doc/调整记录/已更新正式环境/视图20210514.1132.sql

USE [befri_Goldhoo]
GO

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE VIEW [basedata].[V_NotInOrderClerkVendors] AS 
SELECT  e.EmployeeId , 
        v.VendorId ,
        v.VendorNumber ,
        v.VendorName ,
        v.ShortName
FROM    basedata.Employee e ,
        basedata.Vendor v
EXCEPT
SELECT  EmployeeId ,
        VendorId ,
        VendorNumber ,
        VendorName ,
        ShortName
FROM    basedata.V_OrderClerkVendors


 
  
GO