mysql 多列union_MySQL 多个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`;

展开