走查代码时看到以下的sql.from 后接两个表用where连接。
看了会,想不出为什么这么写的理由,因为既然已经用inner join了完全可以都改用此方式.
而且改过后的效率还更高
看了会,想不出为什么这么写的理由,因为既然已经用inner join了完全可以都改用此方式.
而且改过后的效率还更高
select d.*,
(select count(*) from Tab_Dailyreport_Loginfo c where
c.info_parentid = d.info_id) count,u.user_truename userName,
u.user_photos userPhotos,u.user_sex userSex,de.dept_name
userDeptName from tab_uum_dept de, tab_dailyreport_loginfo
d inner join view_dailyreport_user u on d.info_userid =
u.user_id where de.dept_id = u.depart_id
and d.INFO_TYPE = 1 order by d.INFO_DATE desc
------------改成全部inner join
select d.*,
(select count(*) from Tab_Dailyreport_Loginfo c where
c.info_parentid = d.info_id) count,u.user_truename userName,
u.user_photos userPhotos,u.user_sex userSex,de.dept_name
userDeptName FROM tab_dailyreport_loginfo
d inner join view_dailyreport_user u on d.info_userid =
u.user_id inner join tab_uum_dept de on de.dept_id = u.depart_id
and d.INFO_TYPE = 1 order by d.INFO_DATE desc