mysql左加入_MySQL左加入子查询*

我在JOIN语句中使用子查询组合了一个相当简单的查询.它仅在我在子查询select中包含*时才有效.为什么？

这很有效

$sql = 'SELECT locations.id, title, name, hours.lobby

FROM locations

LEFT JOIN states ON states.id = locations.state_id

LEFT JOIN (SELECT *, type_id IS NOT NULL AS lobby FROM location_hours) AS hours ON locations.id = hours.location_id

GROUP BY locations.id';

这没有

$sql = 'SELECT locations.id, title, name, hours.lobby

FROM locations

LEFT JOIN states ON states.id = locations.state_id

LEFT JOIN (SELECT type_id IS NOT NULL AS lobby FROM location_hours) AS hours ON locations.id = hours.location_id

GROUP BY locations.id';

我应该这样做吗？如果你不需要所有的领域,我认为*不是最好的？