b.remark, a.remark) remark, COALESCE(b.update_time, a.update_time) update_time, c.employee_name FROM t_medical_treatment_list a LEFT OUTER JOIN t_medical_treatment_link b ON (a.list_number = ...