select year(c.订购日期) yy ,month(c.订购日期) mm, sum(d.数量*d.单价)ss, concat(ifnull(abs(round((sum(d.数量*d.单价)-ss1)/ss1*100,2)),0),'%') 同比 ,
concat (ifnull(abs(round((sum(d.数量*d.单价)-ss2)/ss2 *100,2)),0),'%') 环比
from 订单明细 c left join 订单 d on c.订单ID=d.订单ID
left join (select month(a.订购日期) mm1,year(a.订购日期)yy1, sum(a.数量*a.单价) ss1 from 订单明细 a left join 订单 d on a.订单ID=b.订单ID group by mm1,yy1) a
on month (c.订购日期)=a.mm1
and a.yy1=year(c.订购日期)-1
left join (select month(a.订购日期) mm2,
year(a.订购日期) yy2, sum(a.数量*d.单价) ss2
from 订单明细 a left join 订单 d on a.订单ID=d.订单ID
group by mm2,yy2) b
on (b.yy2=year(c.订购日期) and b.mm2+1=month(c.订购日期) or (yy2=year(c.订购日期)-1
and b.mm2=12 and month (c.订购日期)=1))
group by yy,mm
order by yy,mm asc(c.订购日期) yy ,(c.订购日期) mm, (d.数量*d.单价)ss, concat((((((d.数量*d.单价)-ss1)/ss1*,)),),) 同比 ,
concat ((((((d.数量*d.单价)-ss2)/ss2 *,)),),) 环比
订单明细 c 订单 d c.订单ID=d.订单ID
((a.订购日期) mm1,(a.订购日期)yy1, (a.数量*a.单价) ss1 订单明细 a 订单 d a.订单ID=b.订单ID mm1,yy1) a
(c.订购日期)=a.mm1
a.yy1=(c.订购日期)-((a.订购日期) mm2,
(a.订购日期) yy2, (a.数量*d.单价) ss2
订单明细 a 订单 d a.订单ID=d.订单ID
mm2,yy2) b
(b.yy2=(c.订购日期) b.mm2+=(c.订购日期) (yy2=(c.订购日期)-b.mm2=(c.订购日期)=))
yy,mm
yy,mm SQL error or missing database (no such column: a.订购日期