mysql 子查询 left join_MySQL left join 与 sub query 子查询是否有区别

sqlexplain

SELECT `info_info`.*, `a`.`name` AS `d1name`

FROM `info_info`

LEFT JOIN (SELECT * FROM `common_diqu`) `a` ON a.id=d1 WHERE `status`=1

ORDER BY `tid` DESC

id select_type table type possible_keys key key_len ref rows Extra

1 SIMPLE info_info ref status status 1 const 129947 Using where; Using filesort

1 SIMPLE common_diqu eq_ref PRIMARY PRIMARY 3 info_info.d1 1 Using where

explain

select i.*,a.name as d1name

from info_info i

left join common_diqu a on i.d1=a.id

where status=1

order by tid desc

id select_type table type possible_keys key key_len ref rows Extra

1 SIMPLE i ref status status 1 const 129948 Using where; Using filesort

1 SIMPLE a eq_ref PRIMARY PRIMARY 3 i.d1 1 Using where