ibatis的result标签顶用select

ibatis的result标签中用select

<select id="get-bp_account_properties" resultClass="accountproperties" parameterClass="java.lang.String">
		select propName, propValue from Properties where AcntIdx = #acntIdx#
	</select>

	<select id="getBankAccount" resultMap="bp_account-result-map" parameterClass="map">
		select a.acntIdx,
				a.bankNo,
				a.bankName,
				a.acntNo,
				a.acntName,
				a.superIdx,
				a.regNo,
				a.regName,
				a.openBankName,
				a.areaCode,
				a.bankBranchCode,
				a.quota,
				a.floorBalance,
				a.memo,
				a.disabled,
				 m.mnyname
		from    a  left  outer  join   m  on  a.currencyno = m.mny
		where a.bankNo like '%$bank$%'
		order by a.acntIdx
	</select>


	<resultMap id="bp_account-result-map" class="accountview">
		<result property="index" column="AcntIdx"/>
		<result property="bankNo" column="BankNo"/>
		<result property="bankName" column="BankName"/>
		<result property="accountNo" column="AcntNo"/>
		<result property="accountName" column="AcntName"/>
		<result property="superIndex" column="SuperIdx"/>
		<result property="regionNo" column="RegNo"/>
		<result property="regionName" column="RegName"/>
		<result property="openBankName" column="OpenBankName"/>
		<result property="areaCode" column="AreaCode"/>
		<result property="bankBranchCode" column="BankBranchCode"/>
		<result property="quota" column="Quota"/>
		<result property="floorBalance" column="FloorBalance"/>
		<result property="comment" column="Memo"/>
		<result property="disabled2" column="Disabled"/>
		<result property="labelList" column="AcntIdx" select="getOfAccount-bp_label"/>
		<result property="attributes2" column="AcntIdx" select="get-bp_account_properties"/>
		<result property="txCodes" column="AcntIdx" select="get-bp_account_action"/>
		<result property="mnyName" column="mnyname"/>
	</resultMap>