坑爹的SQL Server 2008 视图编辑器

SELECT dbo.v_Party_Category_ProvCity.ID, dbo.v_Party_Category_ProvCity.Title, dbo.v_Party_Category_ProvCity.PartyTime, dbo.v_Party_Category_ProvCity.PartyTimeText,
dbo.v_Party_Category_ProvCity.IndexPicture, dbo.v_Party_Category_ProvCity.CategoryID AS Address, dbo.v_Party_Category_ProvCity.FaceTo AS CategoryID,
dbo.v_Party_Category_ProvCity.YouHuiInfo AS ChengBan, dbo.v_Party_Category_ProvCity.FeiYong AS Tel, dbo.v_Party_Category_ProvCity.BaoMingEndTime AS RenShuBoy,
dbo.v_Party_Category_ProvCity.Notice AS RenShuGirl, dbo.v_Party_Category_ProvCity.DutyAnnounce AS FeiYong, dbo.v_Party_Category_ProvCity.PartyGuide AS BaoMingEndTime,
dbo.v_Party_Category_ProvCity.[Content] AS BaoMingText, dbo.v_Party_Category_ProvCity.DocFile AS Notice, dbo.v_Party_Category_ProvCity.AddTime AS DutyAnnounce,
dbo.v_Party_Category_ProvCity.CityID AS PartyGuide, dbo.v_Party_Category_ProvCity.ViewNum AS [Content], dbo.v_Party_Category_ProvCity.ResultDescription AS AddTime,
dbo.v_Party_Category_ProvCity.State AS CityID, dbo.v_Party_Category_ProvCity.Array AS ToAgencyID, dbo.v_Party_Category_ProvCity.PayDiscount AS ViewNum,
dbo.v_Party_Category_ProvCity.LinkUrl AS ClientInfo, dbo.v_Party_Category_ProvCity.HN_NoticeIDs AS ResultDescription, dbo.v_Party_Category_ProvCity.ShowInWeb AS State,
dbo.v_Party_Category_ProvCity.ShowInSoft AS JingDian, dbo.v_Party_Category_ProvCity.NoticeNum AS PayType, dbo.v_Party_Category_ProvCity.YuJoinNum AS PayValue,
dbo.v_Party_Category_ProvCity.TrueJoinNum AS LinkUrl, dbo.v_Party_Category_ProvCity.ChargeNum AS CategoryName, dbo.v_Party_Category_ProvCity.ShiDaoNum AS CityName,
dbo.v_Party_Category_ProvCity.ChargeTotal AS ToDataType, dbo.v_Party_Category_ProvCity.CategoryName AS PosID, dbo.v_Party_Category_ProvCity.CityName AS RecommendTime,
dbo.Recommend.ToDataType AS StartTime, dbo.Recommend.PosID AS EndTime, dbo.Recommend.AddTime AS RecommendArray, dbo.Recommend.StartTime AS RecommendID,
dbo.Recommend.EndTime, dbo.Recommend.Array AS RecommendArray, dbo.Recommend.ID AS RecommendID
FROM dbo.Recommend INNER JOIN
dbo.v_Party_Category_ProvCity ON dbo.Recommend.ToDataID = dbo.v_Party_Category_ProvCity.ID
WHERE (dbo.Recommend.ToDataType = 2)