select pol.*,pss.sub_sys_name as sub_sys_name, --子系统名pui.user_name as oper_user_name, --用于名pui.real_name as oper_real_name, --用户真名psf.fun_name as fun_name, --功能点名psm.mod_name as mod_name, --模块名poi.org_name as org_name, --组织机构名office_list.org_name as office_name, --派出所名station_list.org_name as station_name --分局名from PT_OPER_LOG polleft join Pt_Sub_System pss on pol.sub_sys_id = pss.idleft join Pt_User_Info pui on pol.oper_id = pui.idleft join PT_SYS_FUN psf on pol.oper_type = psf.idand pol.sub_sys_id = psf.sub_sys_idleft join PT_SYS_MODULE psm on pol.mod_id = psm.mod_idleft join pt_org_info poi on pui.org_id = poi.idleft join (select *from (select *from pt_org_info poistart with id = poi.idconnect by id = prior par_id)) office_list on office_list.id =poi.par_idleft join (select *from (select *from pt_org_info poistart with id = poi.idconnect by id = prior par_id)) station_list on station_list.id =office_list.par_id