mysql 多表联查条件赋值问题？

ninth_spring

于 2021-01-13 17:48:07 发布

阅读量551

点赞数

CC 4.0 BY-SA版权

分类专栏： java进阶之路

本文链接：https://blog.youkuaiyun.com/ninth_spring/article/details/112578463

java进阶之路专栏收录该内容

61 篇文章

订阅专栏

博客提到分开给条件可保证左表字段全部显示，且右表不影响左表，涉及数据库表操作相关信息技术内容。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

<select id="selectDetailByQueryPriceId" resultType="com.shop.core.beans.responseBeans.officePrice.QueryPriceResponse"  >
    select cqpe.id as id ,
           cqpe.query_price_id as queryPriceId,
           cqpe.offer_price_detail_id as offerPriceDetailId,
           cqpe.goods_common_id as goodsCommonId,
           cqpe.goods_common_name as goodsCommonName,
           cqpe.goods_sku_id as goodsSkuId,
           cqpe.goods_sku_name as goodsSkuName,
           cqpe.goods_image as goodsImage,
           cqpe.number as number,
           cqpe.goods_unit as goodsUnit,
           cqpe.remark as remark,
           cope.goods_price as goodsPrice
    from club_query_price_detail cqpe left join ( SELECT * FROM club_offer_price_detail WHERE offer_price_user= #{shopId,jdbcType=VARCHAR} ) cope on  cqpe.id =cope.query_detail_price_id
    where cqpe.query_price_id = #{queryPriceId,jdbcType=VARCHAR}
  </select>

在这里插入图片描述
分开给条件，这样就能保证左表字段全部出来。右表不影响左表。