表名：ZL_Order_ProSaleView

简要说明：

ZL_Order_ProSaleView

GO

CREATE VIEW  [dbo].[ZL_Order_ProSaleView] AS

SELECT A.Pronum,A.AllMoney,A.ProID,ZL_Commodities.Proname,ZL_Commodities.Nodeid,ZL_Node.NodeName,ZL_Orderinfo.PaymentNo,ZL_Orderinfo.OrderStatus,ZL_Payment.PayTime

,ZL_Orderinfo.StoreID

FROM ZL_CartPro A 

LEFT JOIN ZL_Commodities ON A.ProID=ZL_Commodities.ID

LEFT JOIN ZL_Node ON ZL_Commodities.NodeID=ZL_Node.NodeID

LEFT JOIN ZL_Orderinfo ON A.Orderlistid=ZL_Orderinfo.ID

LEFT JOIN ZL_Payment ON ZL_Orderinfo.PaymentNo=ZL_Payment.PayNo


--注意：将清空全表数据

detele from ZL_Order_ProSaleView

--注意：将删除整个表

drop table ZL_Order_ProSaleView

--注意：清空且复位表ID序列为初始值

TRUNCATE table ZL_Order_ProSaleView