兄弟理解一下,这个是项目文件,不可以外传,视图sql数据查询目前是这么写的
SELECT
Plant,
SubPlant AS Subplant,
Workshop,
Line,
GroupName AS Groupname,
FacilityCode,
FacilityName,
Plant || '_' || SubPlant || '_' || FacilityCode AS QRCode
FROM
[puc_workshop1]
WHERE
Plant IS NOT NULL
AND SubPlant IS NOT NULL
AND FacilityCode IS NOT NULL
可以的话,您帮我看看代码,如果有问题,麻烦指出一下哈 |