关联大数据表查询

最新推荐文章于 2024-07-11 16:14:02 发布

我爱呢晴天

最新推荐文章于 2024-07-11 16:14:02 发布

阅读量918

点赞数

分类专栏：数据库

本文链接：https://blog.csdn.net/qq_21110835/article/details/104775822

版权

数据库专栏收录该内容

9 篇文章 0 订阅

订阅专栏

 <select id="selectListOfUserByGroupDonationID" parameterType="com.zgshfpw.grd_api.entity.po.ParamsPO" resultMap="GroupDonationListResultMap2" >
      select
       f.DONATE_NUM, f.DONATED_TIME,f. USER_ID, a.BLCURL ,a.AFR052,
      (select u.uus035 from cmsys.uu01 u where u.uus001 = a.acr026) as nickName,
      (select u.uus213 from cmsys.uu01 u where u.uus001 = a.acr026)  as userPic
      from FC_GROUPDONATION_LIST  f, FB01  a
      where f.PTS_ORDER_ID = a.AFQ003
      and f.groupdonation_id = #{groupdonationId,jdbcType=VARCHAR}
      and f.creator_id = #{epId,jdbcType=BIGINT}
      and f.status = 1
      <if test="sort != null and sort == '1'.toString()">
        order by f.DONATED_TIME desc
      </if>
      <if test="sort != null and sort == '2'.toString()">
      order by f.DONATE_NUM desc
      </if>
    </select>

cmsys.uu01为用户表，数据量很大，关联查询时，把它当做一个字段去查询，不要关联整表