FROM #TranID tId Join eft.[Tran] t on tId.id = t.TranID

INNER JOIN dbo.State ON dbo.State.StateId = t.StateId

JOIN Partner p ON t.partnerID = p.partnerID

But the result are...

I use the dbo.State table for the another fields why do you need to inner join it.....i'm new at database more of web developer

hi

Give me 1/2 hour to fix thing from asp.net and I'll get back to you.....

ALTER PROCEDURE [Eft].[SelectEditState]

(

@TranID varchar(max)

)

CREATE TABLE #TranID (id varchar(max) )

IF @TranID is not null

BEGIN

INSERT INTO #TranID select item FROM dbo.CommaSplit(@TranID)

END

SELECT

dbo.State.StateId, t.[dateTime] as [dateTime], p.partner as partner,...

Hi all

I have the same problem, i referencing a table before the Join, how do I solve it?