mysql内嵌查询

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.cgd.pay.dao.SubAcctInfoMapper">
  <resultMap id="BaseResultMap" type="com.cgd.pay.po.SubAcctInfo">
    <id column="SUB_ACCT_NO" jdbcType="VARCHAR" property="subAcctNo" />
    <result column="SUB_ACCT_NAME" jdbcType="VARCHAR" property="subAcctName" />
    <result column="ORG_ID" jdbcType="BIGINT" property="orgId" />
    <result column="MAIN_ACCT_NO" jdbcType="VARCHAR" property="mainAcctNo" />
    <result column="OVERDRAFT" jdbcType="DECIMAL" property="overdraft" />
    <result column="CCY" jdbcType="VARCHAR" property="ccy" />
    <result column="BALANCE" jdbcType="DECIMAL" property="balance" />
    <result column="STATUS" jdbcType="CHAR" property="status" />
    <result column="SERVICE_TYPE" jdbcType="INTEGER" property="serviceType" />
    <result column="USED_OVERDRAFT" jdbcType="DECIMAL" property="usedOverdraft" />
    <result column="PROJECT_ID" jdbcType="BIGINT" property="projectId" />
    <result column="LOGIN_ID" jdbcType="BIGINT" property="loginId" />
    <result column="CREATE_DATE" jdbcType="DATE" property="createDate" />
    <result column="CREATE_ORG_ID" jdbcType="BIGINT" property="createOrgId" />
    <result column="UPDATE_ID" jdbcType="BIGINT" property="updateId" />
    <result column="UPDATE_DATE" jdbcType="DATE" property="updateDate" />
    <result column="UPDATE_ORG_ID" jdbcType="BIGINT" property="updateOrgId" />
  </resultMap>
  <resultMap id="ExtResultMap" type="com.cgd.pay.atom.bo.SubAcctInfoExt" extends="BaseResultMap">
    <id column="SUB_ACCT_NO" jdbcType="VARCHAR" property="subAcctNo" />
    <result column="MAIN_ACCT_NAME" jdbcType="VARCHAR" property="mainAcctName" />
    <result column="SUPERIOR_ORG_ID" jdbcType="BIGINT" property="superiorOrgId" />
    <result column="SOURCE" jdbcType="VARCHAR" property="source" />
    <result column="OPEN_BANK" jdbcType="VARCHAR" property="openBank" />
  </resultMap> 

<!-- 子账号联动主账号查询 -->

  <select id="selectWihtMainAcct" parameterType="Map" resultMap="ExtResultMap">
    select 
    *
    from
    (
select 
s.*,
m.org_id as SUPERIOR_ORG_ID,m.MAIN_ACCT_NAME,m.source
from d_sub_acct_info s
inner join d_main_acct_info m
on s.main_acct_no=m.MAIN_ACCT_NO        
where 1=1
        <if test="subAcctNo != null">
          AND SUB_ACCT_NO=#{subAcctNo,jdbcType=VARCHAR}
        </if>
        <if test="serviceType != null">
          AND  SERVICE_TYPE=#{serviceType,jdbcType=INTEGER}
        </if>    
        <if test="orgId != null">
           AND s.ORG_ID=#{orgId,jdbcType=BIGINT}
        </if>       
        <if test="serviceType != null">
           AND SERVICE_TYPE=#{serviceType,jdbcType=INTEGER}
        </if>              
        <if test="projectId != null">
           AND PROJECT_ID=#{projectId,jdbcType=BIGINT}
        </if>  
     ) as n
     where 1=1
     <if test="superiorOrgId != null">
        AND SUPERIOR_ORG_ID=#{superiorOrgId,jdbcType=BIGINT}
     </if>
     <if test="source != null">
        AND SOURCE=#{source,jdbcType=VARCHAR}
     </if>                      

  </select>

</mapper>