mybatis级联查询的新写法

先定义需要查询到的字段名称，在写级联查询语句

 <sql id="Base_Column_List" >    CUSTOMER_ID, CUSTOMER_NAME, CUSTOMER_PHONE_NUM, CUSTOMER_EMAIL, DEPART_ID, TEAM_ID,     DESK_NUM, STATUS, TAG, TEAM_NAME, DEPART_NAME  </sql>    <select id="queryById" resultMap="CustomerInfoMap" parameterType="java.lang.Integer" >    select     <include refid="Base_Column_List" />    from (    SELECT C.*,T.TEAM_NAME,D.DEPART_NAME FROM CUSTOMER_INFO_T CLEFT JOIN DEPART_INFO_T D ON C.DEPART_ID=D.DEPART_IDLEFT JOIN TEAM_INFO_T T ON C.TEAM_ID=T.TEAM_ID)    where CUSTOMER_ID = #{customerId,jdbcType=INTEGER}  </select>