【mysql错误】UNION ALL查询结果集中查询对应列出现错误"Every derived table must have its own alias"

SELECT * FROM 
    (SELECT a.CHARGE_TYPE as 复选框扣费类型 FROM a -- 特意弄个字段
         UNION ALL
     SELECT a.CHARGE_TYPE as 复选框扣费类型 FROM a
    ) 
 WHERE a.id='129' and 复选框扣费类型 != 'PROMOTION' -- 在外面做条件用SELECT * FRO