逻辑表有主键 关联到视图的逻辑表是有主键的 我测试了一个简单的试图 2个简单的表 只有2个字段 字段一样 union all 出来的结果 做一个视图 建立逻辑表指向视图 是可以上传文件的 文档关联没有问题
但是我这个稍微复杂点的union all 就不行 不知道问题是什么
可以上传的SQL视图 TestID是逻辑表主键
SELECT TestID,TestName from TestUnionA
UNION ALL
SELECT ID as TestID,TestName from TestUnionB
无法上传的视图 MAKEID是逻辑表主键
SELECT TP.ProjectName, TM.CPJTH, TM.CPJMC, TC.FValue AS CPJLX, TMS.EbilityRate,
TMS.FirstRate, TMS.SecondRate, TMS.ThirdRate, TMS.FouthRate, TMS.FifthRate,
TMS.NewRate, TMS.DetectDate, TMS.FirstDate, TMS.SecondDate, TMS.ThirdDate,
TMS.FouthDate, TMS.FifthDate, TMS.NewDate, TMS.Detectperson,
'设置' AS SetUpRate, '修改' AS ModifyRate, TM.MakeID, TP.ProjectID
FROM AM_TPROJECT2 TP
JOIN AM_TMAKE TM ON TP.ProjectID = TM.MakeProjectID
LEFT JOIN AM_TConfig TC ON TC.FKey = TM.CPJLX AND TC.FType = '制件类型'
LEFT JOIN AM_TMass TMS ON TM.MakeID = TMS.MakeCode AND TP.ProjectID = TMS.projectCode
WHERE TM.IsSplited = 0
UNION ALL
SELECT TP.ProjectName, TM.CPJTH, TM.CPJMC, TC.FValue AS CPJLX, TMS.EbilityRate,
TMS.FirstRate, TMS.SecondRate, TMS.ThirdRate, TMS.FouthRate, TMS.FifthRate,
TMS.NewRate, TMS.DetectDate, TMS.FirstDate, TMS.SecondDate, TMS.ThirdDate,
TMS.FouthDate, TMS.FifthDate, TMS.NewDate, TMS.Detectperson,
'设置' AS SetUpRate, '修改' AS ModifyRate, TM.ID as MakeID, TP.ProjectID
FROM AM_TPROJECT2 TP
JOIN AM_TMAKESplit TM ON TP.ProjectID = TM.MakeProjectID
LEFT JOIN AM_TConfig TC ON TC.FKey = TM.CPJLX AND TC.FType = '制件类型'
LEFT JOIN AM_TMass TMS ON TM.ID = TMS.MakeCode AND TP.ProjectID = TMS.projectCode
JOIN AM_TMake TMK ON TMK.MakeID = TM.OriMakeID
WHERE TMK.IsSplited <> 0
期待指点 |