您现在的位置是：主页 > news > 用html框架做网站/公司模板建站
用html框架做网站/公司模板建站
admin2025/5/4 17:10:24【news】
简介用html框架做网站,公司模板建站,网站秒杀怎么做,无极网络科技有限公司这个语句加了join和union后就错了，请高手指教一下，怎么改好，先谢谢了。insertintolevel-1metric(Year,Quarter,COGS,TotalCosttoServe)select*from(SELECTCOST1.Year,C...这个语句加了join 和union 后就错了，请高手指教一下&#…
这个语句加了join和union后就错了，请高手指教一下，怎么改好，先谢谢了。insertinto`level-1metric`(`Year`,`Quarter`,`COGS`,`TotalCosttoServe`)select*from(SELECTCOST1.`Year`,C...
这个语句加了join 和union 后就错了，请高手指教一下，怎么改好，先谢谢了。
insert into `level-1 metric`(`Year`,`Quarter`,`COGS`,`Total Cost to Serve`)
select * from
(
SELECT COST1.`Year`,COST1.`Quarter`,COST2.`COGS`,COST2`.TCS FROM
(
SELECT `Year`,`Quarter`,
sum(case when `Total Cost to Serve`>"0" then `Total Cost to Serve` else `COGS`+`Total SCM Cost` end) as `TCS`
from `cost1`
group by `Year`,`Quarter`
)AS COST2
LEFT JOIN `cost1` AS COST3
ON `COST2`.`Year`=`COST3`.`Year` and `COST2`.`Quarter`=`COST3`.`Quarter`
------------以上这段没问题，但是我想加上下面union all 这段后就报错，
union all
SELECT COST4.`Year`,COST4.`Quarter`,COST4.`COGS`,COST4.TCS FROM
(
SELECT `Year`,“Average”, /*就是这里和上面那一段不一样，而且分组只是按照“Year”分组
sum(case when `Total Cost to Serve`>"0" then `Total Cost to Serve` else `COGS`+`Total Supply Chain Management Cost` end) as `TCS`
from `cost1`
group by `Year`
)AS COST4
LEFT JOIN `cost1` AS COST5
ON `COST4`.`Year`=`COST5`.`Year`
)as COST 6
on duplicate key update `level-1 metric`.`COGS`=`cost6`.`COGS`,`level-1 metric`.`Total Cost to Serve`=`cost6`.`Total Cost to Serve`;
展开
