表名：ZL_Order_ShareView

简要说明：

ZL_Order_ShareView

GO

CREATE VIEW [dbo].[ZL_Order_ShareView] AS

SELECT A.*,B.HoneyName RHoney,B.UserName RUName,B.salt AS UserFace FROM 

(SELECT A.*,B.HoneyName AS CHoney,B.UserName AS CUName,B.GroupID FROM ZL_Order_Share A LEFT JOIN ZL_User B ON A.UserID=B.UserID) AS A

LEFT JOIN ZL_User AS B ON A.ReplyUid=B.UserID


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

detele from ZL_Order_ShareView

--注意：将删除整个表

drop table ZL_Order_ShareView

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

TRUNCATE table ZL_Order_ShareView