潍坊仿站定制模板建站_汕头建设免费网站_有什么平台可以推广_危机舆情公关公司

1. 涉及表

表	表名	功能
ps_income_materials	来料管理表	来料入库
ps_material_out	来料出库记录	来料出库

2. 业务:材料盘点

**将ps_income_materials来料入库表与ps_material_out来料出库记录表关联查询 **

       SELECT mb.name as base_name,mm.name as model_name,sum(m.quantity) as quantity,mm.unit from(select name as material_id,base_id,quantity from ps_income_materialsunionselect material_id,base_id,-quantity as quantity from ps_material_out) mleft join ps_material_base mb on mb.id = m.base_idleft join ps_material_model mm on mm.id = m.material_idGROUP BY m.base_id,m.material_id