select drc_users.name,
vehicles.total_vehicles,
COUNT(distinct drivers.id) as total_drivers
from drc_users
LEFT join brc_users on drc_users.id = brc_users.district_id
left join crc_users on crc_users.block_id = brc_users.id
left join schools on schools.cluster_id = crc_users.id
left join (select count(id) total_vehicles from vehicles) on vehicles.school_id = schools.id
left join drivers on drivers.school_id = schools.id
where drc_users.district_id = 2401
我正在使用 mariadb 10.5.12
需要有关此查询问题的帮助。
错误在以下行中:
括号中的每个查询都必须被赋予一个别名,然后可以使用该别名在外部查询的其余部分引用它。
将其更改为:
那应该是
vehicles.total_vehicles
因为在子查询中你有: