sql - SQL Query 使用 Sum() 连接两个查询

Question

我知道这对你们 sql 人来说很简单，但我试图将两个简单的查询合二为一。从代码中可以明显看出 job.ActiveJob.ID = job.EstimateTbl.ID_Job。

我正在尝试获取：id、JobName、sum(itemAmount)

谢谢你的帮助。

SELECT a.id, a.JobName
FROM job.ActiveJobsTbl AS a
WHERE a.ID = '100' 

SELECT SUM(itemAmount)
FROM job.EstimateTbl
WHERE ID_Job = '100'

标签： sqlsql-server

Answer 1

您可以JOIN通过 表格ON E.ID_Job = A.ID并获取SELECT值GROUP BY

SELECT A.id, A.JobName, SUM(E.itemAmount) AS Amount 
FROM job.ActiveJobsTbl AS A
INNER JOIN job.EstimateTbl E ON E.ID_Job = A.ID 
WHERE A.ID = '100'  
GROUP BY A.id, A.JobName;