确认sql: select * from ( select material_id,sum(jit.jit_stock_sum_qty * jit.unite_price) a,'201705' from tb_usc_monthly_balance_dtl_jit jit where jit.account_period = '201705' and jit.wh_id = '100109' group by material_id union select material_id,sum(jit.jit_stock_sum_qty * jit.unite_price),'201704' from tb_usc_monthly_balance_dtl_jit jit where jit.account_period = '201704' and jit.wh_id = '100109' group by material_id union select material_id,sum(t.quantity*t.trade_price),'flow' from tb_usc_monthly_balance_dtl_flw t where t.account_period='201705' and t.wh_to_id='100109' group by material_id) t where t.a!=0 order by 1,3
|