查询 中 selectKey有关问题

查询 中 selectKey问题select ORGNAME from paOrganization where roleId#roleName# and parentId in (se

查询 中 selectKey问题

select ORGNAME from paOrganization where roleId=#roleName# and parentId in (  select top 1 orgId from paOrganization where roleId=#roleName# and orgUrl=#orgUrl#) and isComp=#isComp#

正常


==========
出场
<select id="getComBtn" resultparameterresult>       select top 1 orgId from paOrganization where roleId=#roleName# and orgUrl=#orgUrl#  </selectKey>    select ORGNAME from paOrganization where roleId=#roleName# and parentId=#parentId# and isComp=#isComp#</select>