旗舰版4.2 采购订单查询报错:the corralation name 't1033' is speci...
金蝶云社区-云社区用户0pI51234
云社区用户0pI51234
0人赞赏了该文章 563次浏览 未经作者许可,禁止转载编辑于2016年08月31日 13:56:53

旗舰版4.2前两填打过PT105510补丁(不知道是否有关系),今天发现其中一个账套打开采购订单序时簿查询时报错:the corralation name 't1033' is specified multiple times in a from clause。截图见附件,后台跟踪发现是:Select top 20000 v1.FTranType as FTranType,v1.FCheckerID as FCheckerID,v1.FInterID as FInterID,u1.FEntryID as FEntryID,v1.Fdate as Fdate,v1.FBillNo as FBillNo,v1.FChangeDate as FChangeDate,v1.FVersionNo as FVersionNo,case when v1.FCheckerID>0 then 'Y' when v1.FCheckerID<0 then 'Y' else '' end as FCheck,CASE WHEN v1.FStatus = 3 OR v1.FClosed = 1 THEN 'Y' ELSE '' END as FClose,case when v1.FCancellation=1 then 'Y' else '' end as FCancellation,v1.FMultiCheckStatus as FNewMultiCheckStatus, 0 As FBOSCloseFlag from POOrder v1 INNER JOIN POOrderEntry u1 ON v1.FInterID = u1.FInterID AND u1.FInterID <>0
INNER JOIN t_ICItem t14 ON u1.FItemID = t14.FItemID AND t14.FItemID <>0
LEFT OUTER JOIN t_ICItem t1033 ON u1.FItemID = t1033.FItemID AND t1033.FItemID<>0
LEFT OUTER JOIN t_Supplier t1033 ON v1.FSupplyID = t1033.FItemID AND t1033.FItemID<>0 where 1=1 AND (v1.FChangeMark=0 AND ( Isnull(v1.FClassTypeID,0)<>1007101))
最后关联的物料和供应商表的别名都叫t1033导致的,不知道是否有办法解决。