读书人

查询 中 selectKey有关问题

发布时间: 2012-10-06 17:34:01 作者: rapoo

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

读书人网 >软件架构设计

热点推荐