select r.role_name,p.privil_name from t_uums_base_role r,t_uums_base_role_privil rp,报这个错not a group by expression 急在线等···· 后边还有t_uums_base_privil p where r.role_id = rp.role_id and rp.privil_id = p.privil_id group by r.rol
来源:学生作业帮助网 编辑:作业帮 时间:2024/08/17 00:34:17
![select r.role_name,p.privil_name from t_uums_base_role r,t_uums_base_role_privil rp,报这个错not a group by expression 急在线等···· 后边还有t_uums_base_privil p where r.role_id = rp.role_id and rp.privil_id = p.privil_id group by r.rol](/uploads/image/z/13852379-11-9.jpg?t=select+r.role_name%2Cp.privil_name+from+t_uums_base_role+r%2Ct_uums_base_role_privil+rp%2C%E6%8A%A5%E8%BF%99%E4%B8%AA%E9%94%99not+a+group+by+expression+%E6%80%A5%E5%9C%A8%E7%BA%BF%E7%AD%89%C2%B7%C2%B7%C2%B7%C2%B7+%E5%90%8E%E8%BE%B9%E8%BF%98%E6%9C%89t_uums_base_privil+p+where+r.role_id+%3D+rp.role_id+and+rp.privil_id+%3D+p.privil_id+group+by+r.rol)
select r.role_name,p.privil_name from t_uums_base_role r,t_uums_base_role_privil rp,报这个错not a group by expression 急在线等···· 后边还有t_uums_base_privil p where r.role_id = rp.role_id and rp.privil_id = p.privil_id group by r.rol
select r.role_name,p.privil_name from t_uums_base_role r,t_uums_base_role_privil rp,
报这个错not a group by expression 急在线等···· 后边还有t_uums_base_privil p
where r.role_id = rp.role_id and rp.privil_id = p.privil_id group by r.role_name
select r.role_name,p.privil_name from t_uums_base_role r,t_uums_base_role_privil rp,报这个错not a group by expression 急在线等···· 后边还有t_uums_base_privil p where r.role_id = rp.role_id and rp.privil_id = p.privil_id group by r.rol
这个不是英语翻译问题,这个是数据库select语言问题,别急,我帮你看一下.
你仔细看一下英文方式下输入的“.”和“_”都没有问题.not a group by expression 的意思是,你的那个集合名不被认识,不是集合的表达方式.你试着简化一下组名.然后debug一下 t_uums_base_role_privil rp,这个部分