查询 中 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>