21 lines
562 B
Transact-SQL
21 lines
562 B
Transact-SQL
IF EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[v_Orgin]'))
|
|
DROP VIEW [dbo].[v_Orgin]
|
|
GO
|
|
/*外部机构视图。这个外部机构指的是入库单的发货机构，
|
|
包含三个档案，分别是；仓库、店铺、供应商
|
|
其中仓库是做调拨单使用，
|
|
店铺是店铺退货单使用，
|
|
供应商是做采购入库使用*/
|
|
CREATE VIEW dbo.v_Orgin
|
|
AS
|
|
SELECT ShopID AS OrginID,MerchantID,Code,Name FROM BasShop
|
|
WHERE [Status] = 1
|
|
UNION ALL
|
|
SELECT StockID,MerchantID,Code,Name FROM BasStock
|
|
WHERE [Status] = 1
|
|
UNION ALL
|
|
SELECT VenderID,MerchantID,Code,Name FROM BasVender
|
|
WHERE [Status] = 1
|
|
GO
|
|
|