select
sd.name as dptName,
pro.`name` as provinceName,
c.`name` as cityName,
a.`name` as areaName,
info.id,
dpt.*,
info.*,
gd.*
from info_sys as info
left join depart as dpt on dpt.dept_namee = info.dept_namee
left join grade as gd on gd.info_sys_id = info.id
left join sys_dept as sd on dpt.dept_namee = sd.dept_id
left join province pro on dpt.province = pro.code_p
left join city c on dpt.city = c.code_c
left join area a on dpt.area = a.code_a
where info.id = #{id}
以上是李大哥写的
以下是我写的
select
info.`id`,
info.`dept_namee`,
dpt.`principal_name`,
dpt.`unit_type`,
info.`sys_name`,
info.`dept_name`,
info.`begin_use_time`,
gd.`pro_grade`,
gd.`pro_time`,
gd.`jug_res`,
gd.`gov_res&