MYSQL合计问题，求大神帮，

[fengyewl]

select '销售' as 'Typed', SH_number,SH_type,SH_brand,SH_colour,SH_Size,SH_amount_tmp as 'sla',SH_Sale,SH_Shopname,SH_Generation_date from sh_sales_record_list
union all
select '退货' as 'Typed', SH_number,SH_type,SH_brand,SH_colour,SH_Size,SH_amount as 'sla',SH_Sale,SH_Shopname,SH_Generation_date from sh_sales_return_record_list

UNION ALL
SELECT '合计' as 'Typed','','','','','',SUM(sla),SUM(SH_Sale),'','' from sh_sales_record_list



[SQL]select '销售' as 'Typed', SH_number,SH_type,SH_brand,SH_colour,SH_Size,SH_amount_tmp as 'sla',SH_Sale,SH_Shopname,SH_Generation_date from sh_sales_record_list
union all
select '退货' as 'Typed', SH_number,SH_type,SH_brand,SH_colour,SH_Size,SH_amount as 'sla',SH_Sale,SH_Shopname,SH_Generation_date from sh_sales_return_record_list

UNION ALL
SELECT '合计' as 'Typed','','','','','',SUM(sla),SUM(SH_Sale),'','' from sh_sales_record_list


[Err] 1054 - Unknown column 'sla' in 'field list'