--------------------------------------------------------
能帮我把 t_stock.FName 加进去吗 我做的老是提示FName字段无效 不知道怎么弄
你们用到3个表
t_icitem 物料表
t_stock 仓库表
icbom bom表
-- select t_ICItem.fdefaultloc as '编号',t_stock.FName as '仓库' from t_ICItem left outer join t_stock on t_ICItem.fdefaultloc = t_stock.fitemid
------------------------------------------------------------
------解决方案--------------------
- SQL code
--...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 [email protected] and t1.fdefaultloc = C.fitemid