select
adr.modifiedname,
adr.modifiedon,
adr.comment_tag,
adr.post_desc,
adr.qualifications,
(
SELECT
GROUP_CONCAT(r.user_name)
FROM
post_recruiter_related r
WHERE
r.post_id = ah.post_id
AND r.isdeleted = 0
) AS recruitPersons
from ad_headhunter_related ah LEFT JOIN ad_release_record adr ON ah.post_id = adr.post_id
where adr.isdeleted=0
HAVING recruitPersons like '%杰%'
ORDER by ah.create_time DESC
我有一条sql语句,其中select里面有一个子句关联另一张表,这条sql单独执行没问题,但是配合PageHelper分页就报错,提示“ SELECT count(0) FROM ad_headhunter_related ah LEFT JOIN ad_release_record adr ON ah.post_id = adr.post_id WHERE adr.isdeleted = 0 AND ah.is_deleted = 0 AND ah.hunter_id = 83 AND adr.post_nameE '%杰%' HAVING recruitPerons LIKE CONCAT('
%', ?, '%')
提示找不到recruitPersons这个列,这是什么原因呢?