SELECT psd.xm from aptitude_person_r apr  
 left join personnel_snapshot_details psd on apr.snapshot_id = psd.snapshot_id  
 where psd.del_flag = 2 and psd.person_type = 2 and apr.aptitude_id = #{id}  

SELECT ap.* from company_aptitude_r car
left join company_info_snapshot cis on car.snapshot_id = cis.id
left join aptitude ap on car.aptitude_id = ap.id
where name like '%阜陽市路達%' and ap.shzt = 7