Help On Msg 207, Level 16, State 1,- On PROCEDURE Expression IN

need help
on expression IN
whan i do this i get an error

Msg 207, Level 16, State 1, Line 17

Invalid column name 't.empID'.





Code Snippet
DECLARE @vempID varchar(500)
set @vempID = '68737477,51622017'
update [nili].[dbo].[tb_pivot_big]
set fld1 = case v.fld1 when '101' then 'a' when '102' then 'd' when '103' then 'u' when '104' then 'j' end
, f1 = case v.fld1 when '101' then 'b' when '102' then 'r' when '103' then 'i' when '104' then 'l' end
, f11 = case v.fld1 when '101' then 'c' when '102' then 't' when '103' then 'd' when '104' then 'm' end

from [nili].[dbo].[tb_pivot_big] t
inner join (select *
from [nili].[dbo].[tb_pivot_big]
where val_orginal = 1) v
on t.empID = v.empID
WHERE (t.val_orginal = 2) AND (charindex(','+CONVERT(varchar,[t.empID])+',',','+@vempID+',')) > 0






whan i run it like this it OK



Code Snippet
SELECT v.Fname, v.empID
FROM dbo.tb_pivot_big AS t INNER JOIN
(SELECT napipot, Fname, empID, new_unit, mhlka_id, mhlka, val_orginal, fld1, f1, f11, fld2, f2, f22, fld3, f3, f33, fld4, f4, f44, fld5, f5, f55, fld6, f6, f66, fld7, f7, f77,
fld8, f8, f88, fld9, f9, f99, fld10, f10, f110, fld11, f_11, f111, fld12, f12, f112, fld13, f13, f113, fld14, f14, f114, fld15, f15, f115, fld16, f16, f116, fld17, f_7,
f117, fld18, f18, f118, fld19, f19, f119, fld20, f20, f220, fld21, f21, f221, fld22, f_22, f222, fld23, f23, f223, fld24, f24, f224, fld25, f25, f225, fld26, f26, f226,
fld27, f27, f227, fld28, f28, f228, fld29, f29, f229, fld30, f30, f330, fld31, f31, f331
FROM dbo.tb_pivot_big
WHERE (val_orginal = 1)) AS v ON t.empID = v.empID
WHERE (t.val_orginal = 2) AND (t.empID IN (68737477, 51622017))


TNX