我需要帮助查询来自另一个表的引用的总和结果,因此我有两个表MASTER_DRAWING_ASSIGNED和FABRICATION
MASTER_DRAWING_ASSIGNED,
HEAD_MARK SUBCONT_ID PROJECT_NAME
---------------------------------
HEADMARKA BOBBY PROCESSHOUSE
HEADMARKB BOBBY PROCESSHOUSE
HEADMARKC ERIC PROCESSHOUSE
制造
HEAD_MARK CURRENT_WEIGHT PROJECT_NAME
-------------------------------------
HEADMARKA 19.5 PROCESSHOUSE
HEADMARKA 23.4 PROCESSHOUSE
HEADMARKA 11.2 PROCESSHOUSE
HEADMARKB 23.3 PROCESSHOUSE
HEADMARKB 10.9 PROCESSHOUSE
HEADMARKC 11.0 PROCESSHOUSE
HEADMARKC 10.5 PROCESSHOUSE
因此,有一天,我想了解一下BOBBY从FABRICATION中当前重量中提取的总重量能得到多少。我很难做到这一点。请帮我
我的查询是这样的
SELECT SUM(CURRENT_WEIGHT)
, MASTER_DRAWING_ASSIGNED.SUBCONT_ID
FROM FABRICATION
, MASTER_DRAWING_ASSIGNED
WHERE MASTER_DRAWING_ASSIGNED.HEAD_MARK = FABRICATION.HEAD_MARK
MASTER_DRAWING_ASSIGNED.PROJECT_NAME = 'PROCESSHOUSE'
AND MASTER_DRAWING_ASSIGNED.SUBCONT_ID = 'BOBBY'
我认为您有错别字和漏写的GROUP BY
子句。另外,您最好使用JOIN
子句和表别名。
SELECT SUM(FABRICATION.CURRENT_WEIGHT),
MASTER_DRAWING_ASSIGNED.SUBCONT_ID
FROM FABRICATION,
MASTER_DRAWING_ASSIGNED
WHERE MASTER_DRAWING_ASSIGNED.HEAD_MARK = FABRICATION.HEAD_MARK AND MASTER_DRAWING_ASSIGNED.PROJECT_NAME = 'PROCESSHOUSE'
AND MASTER_DRAWING_ASSIGNED.SUBCONT_ID = 'BOBBY'
GROUP BY MASTER_DRAWING_ASSIGNED.SUBCONT_ID
本文收集自互联网,转载请注明来源。
如有侵权,请联系 [email protected] 删除。
我来说两句