数据库中查询语句怎么设置别名

<association property="sale" javaType="cc.moredo.domain.Sales">
          <id column="sid" property="id" jdbcType="INTEGER" />
        <result column="sale_price" property="salePrice" jdbcType="DOUBLE" />
        <result column="sale_des" property="saleDes" jdbcType="VARCHAR" />
        <result column="sale_small" property="saleSmall" jdbcType="INTEGER" />
        <result column="sale_amount" property="saleAmount" jdbcType="INTEGER" />
        <result column="flag" property="flag" jdbcType="VARCHAR" />
      </association>
  </resultMap>
  <sql id="Base_Column_List" >
    id, agency_id, sales_id
  </sql>
  <select id="selectByPrimaryKey" resultMap="BaseResultMap" parameterType="java.lang.Integer" >
    select
    <include refid="Base_Column_List" />
    from agency_sale
    where id = #{id,jdbcType=INTEGER}
  </select>
 
  <select id="selectBySelective" resultMap="allResultMap" parameterType="cc.moredo.domain.AgencySale" >
    SELECT ass.*, s.id as sid,s.sale_price,s.sale_des,s.sale_small,s.sale_amount,s.flag from agency_sale ass, sales s
    <where>
    ass.sales_id = s.id
      <if test="agencyId != null" >
        and ass.agency_id = #{agencyId,jdbcType=INTEGER}
      </if>
      <if test="salesId != null" >
        and ass.sales_id = #{salesId,jdbcType=INTEGER}
      </if>
    </where>