SQL语句问题_慕课猿问

SQL语句问题

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 'report_goods,report_transact WHERE report_goods.goods_id=report_transact.goods_i' at line 1报错说我的sql语句有问题，但是没检查到错误，，，，，请大神帮忙看看

查看完整描述

4 回答

第五若雪

TA贡献14条经验获得超19个赞

SQL语句是什么

反对回复 2017-10-31

第五若雪

TA贡献14条经验获得超19个赞

照片看不到

反对回复 2017-10-31

慕粉1472458902
sql="SELECT SUM(number) sumNumber from report_transact where goods_id="+profit.getGoods_id();

回复 2017-10-31
慕粉1472458902
sql="SELECT COUNT(transact_id) count FROM report_transact WHERE goods_id="+profit.getGoods_id();

回复 2017-10-31
慕粉1472458902
版本5.7.19

回复 2017-10-31

第五若雪

TA贡献14条经验获得超19个赞

MySQL版本

反对回复 2017-10-31

慕粉1472458902
sql="select report_transact.goods_id goods_id,goods_name name,cost_price costPrice,sell_price sellPrice" + "FROM report_goods,report_transact" + " WHERE report_goods.goods_id=report_transact.goods_id " + "GROUP BY goods_name;";

回复 2017-10-31

热搜

最近搜索清空

SQL语句问题

SQL语句问题

4 回答

添加回答