USE [MogoData355]
GO
/****** Object: StoredProcedure [dbo].[GetUserWithdrawDetailByWOID] Script Date: 07/02/2013 21:12:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[GetUserWithdrawDetailByWOID]
@WOID int
AS
BEGIN
select User_Withdraw_Detail.Amount, User_Financial.Contact, User_Withdraw_Detail.ID, User_Withdraw_Detail.LastModifyDate, User_Withdraw_Detail.RealityAmount, User_Withdraw_Detail.[Status] ,User_Withdraw_Detail.Tax, User_Withdraw_Detail.WFID, User_Withdraw_Detail.WOID
from User_Withdraw_Detail
inner join User_Financial on User_Financial.ID = User_Withdraw_Detail.WFID
where User_Withdraw_Detail.WOID = @WOID
END