各位请看:表结构如下:ID,empid(员工id),materielid(物料id),num(物料数量),vtype(该笔记录物料操作状态:0:领料;1:退料;2:出库)
ID,empid,materielid,num,vtype1, 114, 1, 10, 0
2, 114, 1, 2, 1
3, 114, 1, 5, 2
4, 114, 2, 8, 0
5, 114, 2, 3,1
6, 114, 2, 5, 2.....
要得到的结果是:找出某一个员工的某种物料的领料数量,退料数量,出库数量请教各位如何写sql语句,谢谢!
ID,empid,materielid,num,vtype1, 114, 1, 10, 0
2, 114, 1, 2, 1
3, 114, 1, 5, 2
4, 114, 2, 8, 0
5, 114, 2, 3,1
6, 114, 2, 5, 2.....
要得到的结果是:找出某一个员工的某种物料的领料数量,退料数量,出库数量请教各位如何写sql语句,谢谢!
SUM(IF(vtype=1,num,0)) AS 退料数量,
SUM(IF(vtype=2,num,0)) AS 出库数量
FROM TT WHERE empid='123' AND materielid='456' GROUP BY empid