关联表并显示关联表ID

dh_n

1. SELECT ROWNUM AS JUSTEP_RN__, JUSTEP_TABLE__.* FROM (SELECT  <font color="#ff0000">ERP_MM_DispatchingRecord.fID</font>,<font color="#dda0dd"> ERP_MM_Groupsublist.fID AS ERP_MM_Groupsublis</font><font color="#ffff00">t</font>, <font color="#ff0000">ERP_MM_ProcedurePlan.fID</font>,
   
2. 
   
3.    ERP_MM_ProductionOrder.FBATCHNO AS fBatchNo, OA_AS_Card.FCODE AS fCode,
   
4.       ERP_MM_GroupMain.FNAME AS fName, ERP_StockArchives.FNORMSTYPE AS fNormsType, ERP_MM_ProcedurePlan.FPLANNEDENDDATE AS fPlannedEndDate,
   
5.        ERP_MM_ProcedurePlan.FPLANNEDSTARTDATE AS fPlannedStartDate
   
6.              FROM ERP_MM_GROUPSUBLIST ERP_MM_Groupsublist
   
7.               LEFT JOIN ERP_MM_GROUPMAIN ERP_MM_GroupMain ON ERP_MM_Groupsublist.FMAINID = ERP_MM_GroupMain.fID
   
8.               LEFT JOIN ERP_ME_WorkCenterMain ERP_ME_WorkCenterMain ON ERP_MM_GroupMain.FWORKCENTERID = ERP_ME_WorkCenterMain.fID
   
9.               LEFT JOIN ERP_ME_WorkCenterDetail ERP_ME_WorkCenterDetail ON ERP_ME_WorkCenterDetail.FDOCUMENTNUMBER = ERP_MM_Groupsublist.FPERSONID
   
10.               LEFT JOIN ERP_MM_DispatchingRecord ERP_MM_DispatchingRecord ON ERP_ME_WorkCenterDetail.fID = ERP_MM_DispatchingRecord.FRESOURCEID
    
11.               LEFT JOIN ERP_MM_ProcedurePlan ERP_MM_ProcedurePlan ON ERP_MM_DispatchingRecord.FPROCEDUREID = ERP_MM_ProcedurePlan.fID
    
12.               LEFT JOIN ERP_MM_ProductionOrder ERP_MM_ProductionOrder ON ERP_MM_ProcedurePlan.FPRODUCEORDERID = ERP_MM_ProductionOrder.fID
    
13.               LEFT JOIN ERP_GY_PTProcedure ERP_GY_PTProcedure ON ERP_MM_ProcedurePlan.FPROCEDURENUM = ERP_GY_PTProcedure.fID
    
14.                LEFT JOIN OA_AS_Card OA_AS_Card ON ERP_MM_Groupsublist.FPERSONID = OA_AS_Card.fID
    
15.                LEFT JOIN ERP_StockArchives ERP_StockArchives ON OA_AS_Card.FSTOCKCODE = ERP_StockArchives.FSTOCKCODE
    
16.                 WHERE  (ERP_MM_Groupsublist.FTYPE = '设备') AND (ERP_MM_ProcedurePlan.FIFCOMPLETED <> '是')   
    
17.                 ORDER BY fCode ASC, fPlannedStartDate ASC, fPlannedEndDate ASC) JUSTEP_TABLE__  WHERE ROWNUM<21
    

复制代码

上面是服务器报错 ，抛出的语句下面的编辑器语句，编辑器执行正常的；
开发版本是Bex5 3.8  部署版本是3.4

a表关联 a b c  ，显示 a b c 表ID，a表显示正常 有别名，b c 没有别名！！！！下面标红的地方是a b 表的别名。为什么服务器会把别名编译没了！！！！！！！！！！！已经正常执行3天了，今天突然报错，希望起步解释一下原因！！！

1. select ERP_MM_Groupsublist.*,ERP_MM_ProductionOrder.fMaterielCode as fMaterielCode,ERP_MM_ProductionOrder.fEditionCode as fEditionCode,ERP_MM_ProductionOrder.fCustomerToken as fCustomerToken,ERP_MM_ProductionOrder.fBatchNo as fBatchNo,ERP_MM_ProductionOrder.fResultNum as fResultNum,ERP_MM_ProcedurePlan.fActualStartDate as fActualStartDate,ERP_MM_ProcedurePlan.fTransferredQuantity as fTransferredQuantity,ERP_MM_ProcedurePlan.fCompletionQuantity as fCompletionQuantity,ERP_MM_ProcedurePlan.fIFcompleted as fIFcompleted,ERP_MM_ProcedurePlan.fTotalManhour as fTotalManhour,ERP_MM_ProcedurePlan.fSurplusTimes as fSurplusTimes,ERP_MM_GroupMain.fName as fName,OA_AS_Card.fCode as fCode,ERP_StockArchives.fStockName as fStockName,ERP_StockArchives.fNormsType as fNormsType,ERP_ME_WorkCenterMain.fName as gName,ERP_MM_ProcedurePlan.fPlannedStartDate as fPlannedStartDate,ERP_MM_ProcedurePlan.fPlannedEndDate as fPlannedEndDate,ERP_MM_ProcedurePlan,ERP_GY_PTProcedure.fProcedureNameID as pProcedureNameID,ERP_GY_PTProcedure.fCode as pCode,((select  (SQL.nvl(sum(ERP_MM_DispatchingRecord.fNumOfWorkers), 0)) as custom2 from ERP_MM_DispatchingRecord ERP_MM_DispatchingRecord  where ERP_MM_DispatchingRecord.fProcedureID = ERP_MM_ProcedurePlan)) as custom1,ERP_MM_DispatchingRecord
   
2.     from ERP_MM_Groupsublist ERP_MM_Groupsublist
   
3.      optional  join ERP_MM_GroupMain ERP_MM_GroupMain on ERP_MM_Groupsublist.fMainID = ERP_MM_GroupMain
   
4.      optional  join ERP_ME_WorkCenterMain ERP_ME_WorkCenterMain on ERP_MM_GroupMain.fWorkCenterID = ERP_ME_WorkCenterMain
   
5.      optional  join ERP_ME_WorkCenterDetail ERP_ME_WorkCenterDetail on ERP_ME_WorkCenterDetail.fDocumentNumber = ERP_MM_Groupsublist.fPersonID
   
6.      optional  join ERP_MM_DispatchingRecord <font color="#ff0000">ERP_MM_DispatchingRecord </font>on ERP_ME_WorkCenterDetail = ERP_MM_DispatchingRecord.fResourceID
   
7.      optional  join ERP_MM_ProcedurePlan <font color="#ff0000">ERP_MM_ProcedurePlan </font>on ERP_MM_DispatchingRecord.fProcedureID = ERP_MM_ProcedurePlan
   
8.      optional  join ERP_MM_ProductionOrder ERP_MM_ProductionOrder on ERP_MM_ProcedurePlan.fProduceOrderID = ERP_MM_ProductionOrder
   
9.      optional  join ERP_GY_PTProcedure ERP_GY_PTProcedure on ERP_MM_ProcedurePlan.fProcedureNum = ERP_GY_PTProcedure
   
10.      optional  join OA_AS_Card OA_AS_Card on ERP_MM_Groupsublist.fPersonID = OA_AS_Card
    
11.      optional  join ERP_StockArchives ERP_StockArchives on OA_AS_Card.fStockCode = ERP_StockArchives.fStockCode
    
12.     where ERP_MM_Groupsublist.fType = '设备' AND ERP_MM_ProcedurePlan.fIFcompleted <> '是'

复制代码

jishuang

具体报什么错？

dh_n

列定义模糊

jishuang

概念中单独定义的有fID这个关系吗？

dh_n

所有的代码都在上面了

jishuang

我是问概念中没有单独定义一个fID的关系？
没有定义就直接用概念别名做为主键关系，而不是用fID