mysql多表左连接查询例子参考

你走开``

于 2017-05-17 15:33:03 发布

阅读量1.6k

点赞数 1

分类专栏： mysql 文章标签： mysql

本文链接：https://blog.csdn.net/qq_34531925/article/details/72394343

版权

本文以OA项目为背景，介绍了如何使用MyBatis生成SQL语句进行MySQL的多表左连接查询，通过示例展示了几种不同的左连接查询方法。

摘要由CSDN通过智能技术生成

OA项目

mybatis参考

<select id="queryList" parameterType="map"
        resultType="com.zhensheng.entity.BusAfficheEntityQuery">

        <!-- 查询该用户的接收公告id -->
        select
        <include refid="afficheField" />
        ,person.is_readed AS isRead,dict.label AS modelName
        from bus_affiche AS
        affiche LEFT JOIN bus_affiche_person AS person
        on affiche.id =
        person.affiche_id AND person.person_id = #{userId}
        JOIN
        sys_dict AS dict
        on dict.id = affiche.affiche_type
        where
        affiche.id in
        (
        select distinct
        receive.missive_id
        from
        bus_affiche_receive AS receive
        <where>
            <!-- 用户id -->
            receive.condition_value =
            <if test="userId != null and userId != ''">
                #{userId}
            </if>
            <!-- 部门id -->
            or receive.condition_value in
            <if test="orgId != null and orgId != ''">
                <foreach collection="orgId" item="oId" open="(" separator=","
                    close=")">
                    #{oId}
                </foreach>