mysql 别名失效

     最近开发中，遇到多表同名列的别名，查询出来的列名失效，后来对列名做trim()处理，别名成功

贴上代码:

queryGotRs.append(" select date_format(m.send_date,'%Y%m%d%H%i%s') as deal_time, ");
queryGotRs.append(" trim(a.rp_sum_value) as rp_value,trim(a.rp_number) as rp_num,trim(a.rob_number) as got_num,trim(m.rp_value) as got_value, ");