MySQL where 查询不能使用别名的解决方法

最新推荐文章于 2024-06-01 21:56:35 发布

liweiwei1419

最新推荐文章于 2024-06-01 21:56:35 发布

阅读量8.4k

点赞数

分类专栏： mysql 文章标签： mysql

本文链接：https://blog.csdn.net/lw_power/article/details/50832361

版权

mysql 专栏收录该内容

14 篇文章 0 订阅

订阅专栏

select * from (SELECT sheng.prov_name,shi.city_name,qu.cnty_name,us.`school_name`,
        (SELECT COUNT(uu.user_id) FROM u_user uu
         JOIN `u_user_role` uur ON uu.user_id = uur.`user_id`
         JOIN `u_classes_user` ucu ON uu.user_id = ucu.user_id
         JOIN `u_classes` uc ON ucu.`classes_id` = uc.classes_id
         JOIN `u_school_grade` usg ON uc.`school_grade_id` = usg.`school_grade_id`
        WHERE uu.user_name LIKE 'lyο%' AND us.school_name IS NOT NULL AND usg.`school_id` = us.`school_id`
        AND uur.role_id = '38') user_student

        FROM `u_school` us 
         JOIN u_distcd qu ON us.`dist_cd` = qu.`dist_cd`
         JOIN u_distcd shi ON qu.`p_dist_cd` = shi.`dist_cd`
         JOIN u_distcd sheng ON shi.`p_dist_cd` = sheng.dist_cd) as a
where user_student > 0 ;