mybatis 三表联合查询

一、实现

使用 LEFT JOIN 语句，具体代码如下：

<sql id="selectDataPeriodInspectContentAll">
            data_period_inspect_content.id, inspect_method, plan_inspect_date, inspector, data_period_inspect_content.rmk,public_id,factory_num, user_department,storage_site, apparatus_name, apparatus_model,
            data_period_inspect_public.year,write_Date,writer,approve_Date,approver
        from data_period_inspect_content LEFT JOIN data_apparatus ON data_period_inspect_content.apparatus_id = data_apparatus.id
                                         LEFT JOIN data_period_inspect_public ON data_period_inspect_content.public_id = data_period_inspect_public.id,
    </sql>

参考链接：https://blog.csdn.net/sjgllllll/article/details/119709387