年初到8月底的經營分析

標籤：時空

年初到8月底的經營分析

select b.spbh,b.spmch,b.shpgg,b.dw,b.shengccj,b.shpchd,sum(case when yue=‘1‘ then a.shqjzhje else 0 end) as 上期結轉金額,sum(a.bqxsshl) 本期銷售數量,sum(a.bqxscbje) 本期銷售成本金額,sum(a.bqxscbje)/8 as 合理周轉,sum(case when yue=‘8‘ then a.bqye else 0 end) as 本期餘額,c.chbdj as 成本單價

from ymjzhk a,spkfk b,spkfjc c

where a.spid=b.spid and b.spid=c.spid

and a.yue in (‘8‘,‘7‘,‘6‘,‘5‘,‘4‘,‘3‘,‘2‘,‘1‘)

and a.nian=‘2015‘

group by b.spbh,b.spmch,b.shpgg,b.dw,b.shengccj,b.shpchd,c.chbdj

order by b.spbh

年初到8月底的經營分析