|
版本: |
|
小版本号: |
|
|
|
数据库: |
|
服务器操作系统: |
|
应用服务器: |
|
客户端操作系统: |
|
浏览器: |
|
|
|
- select p.fcreatetime,t.*, t.rowid from ERP_GY_TECHNICSPLAN t
- left join ERP_ArchivesTechnics p on t.ffigurenumber=p.ffigurenumber and t.fdrawingversion=p.fdrawingversion
- where t.ffigurenumber='186854-021'
复制代码- select t.*,b.sName as sName,c.sName as sName1,d.sName as sName2,e.sName as sName3,f.fSubmitDate as fSubmitDate,f.fSignDate as fSignDate,f.fReviewDate as fReviewDate,f.fApprovalDate as fApprovalDate,f.fCreateTime as fCreateDate,s.fStockName as StockName,s.fNormsType as fNormsType,u,u.fName as fName,f.fCreateTime as dCreateTime,ERP_MM_BOMMaster.fBOMState as nBOMState
- from ERP_GY_TechnicsPlan t
- optional join SA_OPPerson b on b = t.fProcedurePsnID
- optional join SA_OPPerson c on c = t.fCreatePsnID
- optional join SA_OPPerson d on d = t.fTaskReceiverID
- optional join SA_OPPerson e on e = t.fTaskAllotPsnID
- optional join ERP_ArchivesTechnics f on f.fTechnicsPlanID = t
- optional join ERP_StockArchives s on t.fFigureNumber = s.fStockCode
- optional join ERP_MeasurementUnit u on s.fMainMeasurementUnitID = u
- optional join ERP_MM_BOMMaster ERP_MM_BOMMaster on t.fFigureNumber = ERP_MM_BOMMaster.fMaterielCode AND t.fDrawingVersion = ERP_MM_BOMMaster.fDrawingVersion
- where t.fFigureNumber = '186854-021'
复制代码
ksql编辑器查询结果和orcl查询不一样,代码和截图如上
|
|