--...
FOperID int default(0)
  --
,FName nvarchar(200) null--加入，你的类型是什么，就改为什么
)         
           
insert into #Mutidata1(fentryid,fbominterid,fitemid,fneedqty,fbomlevel,fitemtype,fparentid,flevelstring,fbom,fmaterieltype,foperid)        
select fentryid,fbominterid,fitemid,fneedqty,fbomlevel,fitemtype,fparentid,flevelstring,fbom,fmaterieltype,foperid        
from #Mutidata        
order by findex 

update #Mutidata1 set FName=t.FName from t_stock t where #Mutidata1.FItemID=t.fitemid;--更新
--再选就可以了
--select * from #Mutidata1

------解决方案--------------------

SQL code
From 
icbom a,t_ICItem t1,t_stock C         
Where t1.FItemID = a.fitemid and   a.finterid=@finterid and t1.fdefaultloc = C.fitemid