Mysql 左连接 LEFT JOIN

总忘记mysql的左连接，记下了好复习

<select id="getList" resultMap="BaseResultMap">
    SELECT pscpm.*, stuu.name AS student_name, teau.name AS teacher_name, th.name AS hospital_name, td.name AS department_name 
FROM
     t_pe_senior_clinical_practice_me pscpm
LEFT JOIN sys_user stuu ON pscpm.stu_id = stuu.id
LEFT JOIN sys_user teau ON pscpm.teacher_id = teau.id
LEFT JOIN t_hospital th ON pscpm.hospital_id = th.id
LEFT JOIN t_department td ON pscpm.department_id = td.id
<where>
    <if test="peClinicalPracticeAssessmentMe.createTimeBegin != null and peClinicalPracticeAssessmentMe.createTimeEnd != null">
                        AND pscpm.create_time between #{peClinicalPracticeAssessmentMe.createTimeBegin} and #{peClinicalPracticeAssessmentMe.createTimeEnd}
                </if>
                <if test="peClinicalPracticeAssessmentMe.stuId != null">
                        AND pscpm.stu_id = #{peClinicalPracticeAssessmentMe.stuId}
                </if>
                <if test="peClinicalPracticeAssessmentMe.teacherId != null">
                        AND pscpm.teacher_id = #{peClinicalPracticeAssessmentMe.teacherId}
                </if>
                <if test="peClinicalPracticeAssessmentMe.signStatus != null">
                        AND pscpm.sign_status = #{peClinicalPracticeAssessmentMe.signStatus}
                </if>
                <if test="peClinicalPracticeAssessmentMe.stuLevel != null">
                        AND pscpm.stu_level = #{peClinicalPracticeAssessmentMe.stuLevel}
                </if>
</where>
</select>

SELECT
	sys_role.*, sys_role_resources.resources_id,
	sys_resource.`name`
FROM
	sys_role
LEFT JOIN sys_role_resources ON sys_role.id = sys_role_resources.sys_role_id
LEFT JOIN sys_resource ON sys_role_resources.resources_id = sys_resource.id
WHERE
	sys_role.id = 35
AND sys_resource.permission = '/department'