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