MySql > select * from ‘left join’

Service scenario 1. Associating a examine table with an examine_resource table 2. Associating a examine table with an examine_user table 3.  select a.id as id, a.them as them, a.time as time, a.createUser as createUser, a.status as status, a.examineResourceId as examineResourceId, a.result as result, eur.resource_id as examineUserResourceId from ( select e.id as id, e.theme as them, e.theme as time, e.create_user as createUser, e.status as status, er.resource_id as examineResourceId, eu.result as result, eu.id as examineUserId from examine e LEFT JOIN examine_resource er on e.id = er.examine_id LEFT JOIN examine_user eu on  e.id = eu.examine_id where eu.job_no = #{jobNo} ) a LEFT JOIN examine_user_resource eur ON a.examineUserId = eur.examine_user_idCopy the code