本帖最后由 Shawn.Liu 于 2023-12-26 17:59 编辑
您好,这个问题是需要查询三张表的数据根据产品和工站计算投入量等字段的和是吗,从demo中看可以参考下方使用视图来实现:
- SELECT "产品","工站",SUM("投入量") AS "投入量",SUM("合格量") AS "合格量",SUM("报废量") AS "报废量"
- FROM (
- SELECT "日期","产品","工站","投入量","合格量","报废量"
- FROM "入站"
- UNION ALL
- SELECT "日期","产品","工站","投入量","合格量","报废量"
- FROM "贴片"
- UNION ALL
- SELECT "日期","产品","工站","投入量","合格量","报废量"
- FROM "出货" )
- GROUP BY "产品","工站"
复制代码
|