在尝试执行一个包含多个表连接的MySQL查询时，遇到了'unknown column in mysql join query'错误，具体表现为列'A.id'无法识别。查询涉及到用户、职位申请、类别、地点等多个表的右连接，并进行了数据聚合操作。错误1054 (42S22)表明存在语法错误。问题可能在于引用的列名拼写错误或未在所有参与连接的表中正确引用。需要检查并确保所有引用的列在所有相关的表中都存在。
select concat(A.id,B.id) as id,
B.distance_from,
A.id as user_id,
B.id as jobapplication_id,
concat(A.firstname,' ',A.surname) as name,
GROUP_CONCAT(E.category separator ',') as jobs,
cast(B.introduction as char(10000) character set utf8) as introduction,
concat(F.citytown,'~',F.latitude,' ',F.longitude) as locationFacet,
F.citytown,
REPLACE(F.citytown,' ','') as citytownnospaces,
concat(F.latitude, ',',F.longitude) as location,
concat('CIRCLE(',F.latitude, ',',F.longitude,', d=',B.distance_from,')') as location_shape,G.province,
B.promoted,
B.promotion_expires,
sum(H.rating)
from user A,
job_application B,
job_application_job_category D,
job_category E,
location F,
province G
right join review H
on H.employee_id =A.id
where A.msisdn_verified=1
and B.location_id = F.id
and F.province_id_id=G.id
and B.applicant_id=A.id
and B.id=D.job_application_id
and E.id=D.job_category_id
and B.promoted = 1
and B.promotion_expires > now()
group by B.id
我不知道为什么会这样
错误1054 (42S22):未知列'A。id' in 'on子句
请帮助修复这个查询
扫一扫
1225
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
