java.sql.SQLException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'count(e.id) as empcount from level as l left join customer as c on c.levelid = l' at line 1 SQL语句:
private String levGetAll_sql = "select l.Recid, l.id, l.name, l.re "
+ "count(l.id) as empcount from level as l "
+ "left join customer as c on c.levelid = l.id "
+ "group by l.id";
private String levGetAll_sql = "select l.Recid, l.id, l.name, l.re "
+ "count(l.id) as empcount from level as l "
+ "left join customer as c on c.levelid = l.id "
+ "group by l.id";
解决方案 »
- 一个关于EL的问题,高手请进
- java.lang.IllegalArgumentException: Null property value for 'clientList[7]'
- 问个在struts后台处理checkbox的问题
- 请问该段代码由什么问题吗?为何无法转发到nulldisp在strtusconfig.xmll映射的jsp页面?
- 用js给struts循环标签里的字段赋值得问题
- 求指点在 annotation 中怎么 给一个变量 赋一个 数组
- 在ibm AIX5.1.2操作系统下,如何用80端口访问jsp网页
- 请问使用什么方法能够知道查找到的数据库记录的个数?
- NetBeans IDE 3.5.1中文版怎么在网页中显示中文?
- 帮忙推荐一下 JSP或 Servlet的牛书吧
- tomcat6.0做的项目在tomcat5.5上发布出错?
- JSP可能是连接数据库 有问题,大家一起帮忙看看
count(l.id) 后面应该有个分组函数
使用count聚合函数时不能同时查询其他字段,除非此字段在group by 中出现
那count(l.id) as empcount 可以放着,但select中的其他字段必须去掉,要么在group by中对此字段分组