SELECT dbo.[产量日报表(过油磨光)].日报表日期, dbo.[产量日报表(过油磨光)].班次,
dbo.[产量日报表(过油磨光)].生产任务单号,
dbo.[产量日报表(过油磨光)].产品名称, dbo.[产量日报表(过油磨光)].产品工序,
dbo.t_Emp.FName, dbo.[计资设定表(过油磨光)].计价条目,
dbo.[计资设定表(过油磨光)].系数, dbo.[产量日报表(过油磨光)].个人面积,
(SELECT a.a / b.b * dbo.[计资设定表(过油磨光)].系数
FROM (SELECT SUM(个人面积) AS a
FROM [产量日报表(过油磨光)]) a,
(SELECT COUNT(DISTINCT (员工id)) AS b
FROM [产量日报表(过油磨光)]) b) AS 各工序工资,
dbo.[产量日报表(过油磨光)].计资年月, dbo.t_Emp.FEmpID
FROM dbo.[计资设定表(过油磨光)] RIGHT OUTER JOIN
dbo.[产量日报表(过油磨光)] ON
dbo.[计资设定表(过油磨光)].AutoId = dbo.[产量日报表(过油磨光)].计价id INNER JOIN
dbo.t_Emp ON dbo.[产量日报表(过油磨光)].员工id = dbo.t_Emp.FEmpID
在查询中进行统计
最新推荐文章于 2021-01-18 18:13:21 发布