表名：ZL_Guest_BarView

简要说明：

ZL_Guest_BarView

GO

CREATE VIEW [dbo].[ZL_Guest_BarView]

AS

SELECT A.*,B.HoneyName FROM (SELECT     B.*, C.Catename, C.ParentID, C.NeedLog,C.[Status] as C_Status,C.SendScore,C.ReplyScore, C.PostAuth, C.BarImage,C.[Desc],C.BarInfo, C.OrderID,C.BarOwner,

(Select COUNT(ID) From ZL_Guest_Bar Where Pid=B.ID ) RCount

FROM ZL_Guest_Bar B  INNER JOIN ZL_Guestcate C ON B.CateID = C.Cateid) A LEFT JOIN ZL_User B ON A.CUser=B.UserID


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

detele from ZL_Guest_BarView

--注意：将删除整个表

drop table ZL_Guest_BarView

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

TRUNCATE table ZL_Guest_BarView