mybatis collection 两个表 字段名称相同 数据被覆盖

问题：mybatis collection 两个表 字段名称相同 数据被覆盖
解决方法：在SQL中取一个不同的别名加以区分
示例：

<resultMap type="Desk" id="resultUserMap">
		<result property="DESK_ID" column="DESK_ID" />
		<result property="NAME" column="NAME" />
		<result property="REMARK" column="REMARK" />
		<collection property="books" ofType="Book" column="DESK_ID">
			<id property="BOOK_ID" column="BOOK_ID" />    
            <result property="NAME" column="bNAME"/>
            <result property="REMARK" column="bREMARK"/>   
            <result property="PRICE" column="PRICE"/> 
		</collection>
	</resultMap>  

	<select id="getBooksByDesk" resultMap="resultUserMap" parameterType="String">
		SELECT d.DESK_ID,d.NAME,d.REMARK,b.BOOK_ID,b.NAME as bNAME,b.REMARK as bREMARK,b.PRICE
		FROM tb_desk d,tb_book b
		WHERE b.desk_id=d.desk_id AND d.desk_id=#{desk_id} 
  	</select>