首頁猿問 SQL語句問題

SQL語句問題

MySQL

慕粉1472458902 2017-10-31 18:07:24

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條經(jīng)驗獲得超19個贊

SQL語句是什么

反對回復 2017-10-31

第五若雪

TA貢獻14條經(jīng)驗獲得超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條經(jīng)驗獲得超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