复杂SQL语句的书写（mybatis中XML文件的核心）

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&