--洢ͼ
--1.ʾƷ

CREATE Procedure Pro_ShowBuyProduct
(
@id int
)
as
select * from yx_buyproduct where yx_id=@id
~
--2.ʾ

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

