SELECT A.部门名, ISNULL(SUM(实际集中采购 + 实际零星支付),0)
FROM 部门表 AS A
LEFT JOIN 预算表 AS B ON A.部门ID=B.部门ID
WHERE A.所属一级部门 ='一级' AND B.项目名称='项目'
FROM 部门表 AS A
LEFT JOIN 预算表 AS B ON A.部门ID=B.部门ID
WHERE A.所属一级部门 ='一级' AND B.项目名称='项目'
FROM 部门表 AS A
LEFT JOIN 预算表 AS B ON A.部门ID=B.部门ID AND B.项目名称='项目'
WHERE A.所属一级部门 ='一级'
FROM 部门表 AS A
LEFT JOIN 预算表 AS B ON A.部门ID=B.部门ID AND B.项目名称='项目'
WHERE A.所属一级部门 ='一级'
FROM 部门表 AS A
LEFT JOIN 预算表 AS B ON A.部门ID=B.部门ID AND B.项目名称='项目'
WHERE A.所属一级部门 ='一级'SELECT A.部门名, ISNULL(SUM(实际集中采购 + 实际零星支付),0)
FROM 部门表 AS A
LEFT JOIN 预算表 AS B ON A.部门ID=B.部门ID AND B.项目名称='项目'
WHERE A.所属一级部门 ='一级'
谢谢您,就是这个结果!
FROM 部门表 AS A
LEFT JOIN 预算表 AS B ON A.部门ID=B.部门ID AND B.项目名称='项目'
WHERE A.所属一级部门 ='一级'
也谢谢你!