CREATE VIEW YX_ViewBuyvote
AS
SELECT YX_Vote.YX_ID, YX_Vote.YX_SellUser, YX_Vote.YX_maiuser, 
      YX_Vote.YX_ProID, YX_Vote.YX_VoteTiem, YX_Vote.YX_VoidType, 
      YX_Vote.YX_hfContent, YX_BuyProduct.YX_ProductName, 
      YX_UserInfo.YX_User
FROM YX_Vote INNER JOIN
      YX_BuyProduct ON YX_Vote.YX_ProID = YX_BuyProduct.YX_ID INNER JOIN
      YX_UserInfo ON YX_Vote.YX_SellUser = YX_UserInfo.YX_UserID
      
~

CREATE VIEW dbo.YX_ViewShopvote2
AS
SELECT dbo.YX_Vote.YX_ID, dbo.YX_Vote.YX_SellUser, dbo.YX_Vote.YX_maiuser, 
      dbo.YX_Vote.YX_ProID, dbo.YX_Vote.YX_VoteTiem, dbo.YX_Vote.YX_VoidType, 
      dbo.YX_Vote.YX_VoteContent, dbo.YX_Vote.YX_hfContent, 
      dbo.YX_Shop.YX_SHOPName, dbo.YX_UserInfo.YX_User
FROM dbo.YX_Vote INNER JOIN
      dbo.YX_Shop ON dbo.YX_Vote.YX_ProID = dbo.YX_Shop.YX_SHOPID INNER JOIN
      dbo.YX_UserInfo ON dbo.YX_Vote.YX_SellUser = dbo.YX_UserInfo.YX_UserID

~


CREATE VIEW dbo.YX_Viewvote
AS
SELECT dbo.YX_Vote.YX_ID, dbo.YX_Vote.YX_SellUser, dbo.YX_Vote.YX_maiuser, 
      dbo.YX_Vote.YX_ProID, dbo.YX_Vote.YX_VoteTiem, dbo.YX_Vote.YX_VoidType, 
      dbo.YX_Vote.YX_hfContent, dbo.YX_Product.YX_ProductName, 
      dbo.YX_UserInfo.YX_User
FROM dbo.YX_Vote INNER JOIN
      dbo.YX_Product ON dbo.YX_Vote.YX_ProID = dbo.YX_Product.YX_ID INNER JOIN
      dbo.YX_UserInfo ON dbo.YX_Vote.YX_SellUser = dbo.YX_UserInfo.YX_UserID


~
  
CREATE VIEW dbo.YX_jppro
AS
SELECT dbo.YX_Product.YX_ProductName, dbo.YX_Product.YX_AddTime, 
      dbo.YX_Product.YX_proyxq, dbo.YX_Product.YX_paimaijssj, dbo.YX_paipai.YX_id, 
      dbo.YX_paipai.YX_proid, dbo.YX_paipai.YX_userid, dbo.YX_paipai.YX_reuserid, 
      dbo.YX_paipai.YX_reusercj, dbo.YX_paipai.YX_adddate, 
      dbo.YX_paipai.YX_proname, dbo.YX_paipai.YX_OK, dbo.YX_paipai.YX_Enddate, 
      dbo.YX_paipai.yx_jsdate, dbo.YX_paipai.yx_paimaizt AS yx_paimaizt
FROM dbo.YX_paipai INNER JOIN
      dbo.YX_Product ON dbo.YX_paipai.YX_proid = dbo.YX_Product.YX_ID


~

CREATE VIEW dbo.YX_viewshopvote
AS
SELECT dbo.YX_Vote.YX_ID, dbo.YX_Vote.YX_SellUser, dbo.YX_Vote.YX_maiuser, 
      dbo.YX_Vote.YX_ProID, dbo.YX_Vote.YX_VoteTiem, dbo.YX_Vote.YX_VoidType, 
      dbo.YX_Vote.YX_VoteContent, dbo.YX_Vote.YX_hfContent, 
      dbo.YX_Shop.YX_SHOPName, dbo.YX_UserInfo.YX_User
FROM dbo.YX_Vote INNER JOIN
      dbo.YX_Shop ON dbo.YX_Vote.YX_ProID = dbo.YX_Shop.YX_SHOPID INNER JOIN
      dbo.YX_UserInfo ON dbo.YX_Vote.YX_maiuser = dbo.YX_UserInfo.YX_UserID



