透视表计件工资数据库，多表统计求助！急

penghaifeng

SQL语句演示文件，可参考下贴2楼：
http://club.excelhome.net/viewth ... amp;authorid=500876

penghaifeng

SQL多表连接，实现数量*工时自动计算：
如附件所示，仅供参考！~~~

半条毛毛虫

谢谢。很好，很热情啊，我是家里的老客户了，一晃认识差不多10年了，好感慨啊，学了很多东西

penghaifeng

SQL多表连接，实现数量*工时自动计算：
你一说，我才看到：原来你真的是“老客户”了！~~~

半条毛毛虫

elect A.姓名,A.零件号,A.车数量,A.铣数量,A.镗数量,A.钳数量,A.临数量,A.车数量*B.车 as 车费用,A.铣数量*B.铣 as 铣费用, A.镗数量*B.镗 as 镗费用,A.钳数量*B.钳 as 钳费用,A.临数量*B.临 as 临费用  from

(select 日期,零件号,零件名称,数量 as 车数量,0 as 铣数量,0 as 镗数量,0 as 钳数量,0 as 临数量,车 as 姓名 from [数据录入$] union all
select 日期,零件号,零件名称,0 as 车数量,数量 as 铣数量,0 as 镗数量,0 as 钳数量,0 as 临数量,铣 as 姓名 from [数据录入$] union all
select 日期,零件号,零件名称,0 as 车数量,0 as 铣数量,数量 as 镗数量,0 as 钳数量,0 as 临数量,镗 as 姓名 from [数据录入$] union all
select 日期,零件号,零件名称,0 as 车数量,0 as 铣数量,0 as 镗数量,数量 as 钳数量,0 as 临数量,钳 as 姓名 from [数据录入$] union all  
select 日期,零件号,零件名称,0 as 车数量,0 as 铣数量,0 as 镗数量,0 as 钳数量,数量 as 临数量,临 as 姓名 from [数据录入$])A,

(select 零件号,车,铣,镗,钳,临 from [零件定额$])B where A.零件号=B.零件号

请教：A是什么意思？B是什么意思？在这个表上对应的是哪个数据？

nkgsm

B是(select 零件号,车,铣,镗,钳,临 from [零件定额$])这个括号内容的别名，A是上述那个括号非常多内容的别名。

surprise

人员产量表和生产记录表分开，加一列“报表编号”做媒介联动，再用数据透视配合。

lyp1980

谢谢分享