Question

关于mybatis的修改语句怎么写的

Answer 1

直接用left join等直接关联查询 select a.hotel_id as otaHotelId,b.hotel_id as hotelNo order a left join hotel b on a.hotel_id=b.channel_hotel_id and a.channel_no=b.channel_code where a.order_no=#{orderNo,jdbcType=VARCHAR}