表名：ZL_Order_PayedView

简要说明：

ZL_Order_PayedView

GO

CREATE VIEW [dbo].[ZL_Order_PayedView] AS

SELECT A.*,B.PayTime,B.PayPlatID FROM ZL_Orderinfo A LEFT JOIN ZL_Payment B 

ON A.PaymentNo=B.PayNo WHERE A.PaymentNO IS NOT NULL AND A.PaymentNO !=''


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

detele from ZL_Order_PayedView

--注意：将删除整个表

drop table ZL_Order_PayedView

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

TRUNCATE table ZL_Order_PayedView