一个SQL语句的问题，总是编译过，请大家给看一下

[roro0311]

SELECT rkdname.ywid AS ywid,"+
　　　 "rkdname.ljno As ljno,"+
　　　 "rkdname.units AS units,"+
　　　 "rkdname.bzsname AS bzsname,"+
"rkdname.spint AS spint,"+
"rkdname.zj AS zj,"+
"rkdname.adddate AS adddate,"+
"rkdname.sgov AS sgov,"+
"rkdname.invoice_no AS invoice_no"+
"rkdname.invoice_date AS invoice_date,"+
"ie.GR_NO AS gr_no,"+
"ie.BILL_NO AS bill_no,"+
"ie.IN_DATE AS in_date,"+
"bgd.mxdno AS mxdno,"+
"bgd.bgdh AS bgdh,"+
"bgd.zch AS zch "+
"FROM ie_gr ie,(SELECT * FROM "+table[i][0]+" WHERE id IN "+
"(SELECT id FROM YWList WHERE typeid="+typeid+" AND status=3)) rkdname,"+
"LEFT JOIN BGD_ZC_MX bgd ON bgd.ywid=rkdname.ywid "+
"WHERE ie.INVOICE_NO=rkdname.INVOICE_NO"+
" AND rkdname.INVOICE_NO IN (select INVOICE_NO from ie_gr)"+
" AND ie.LJNO<>rkdname.LJNO"+
" AND ie.QUANTITY<>rkdname.spint"+
" AND ie.AMOUNT<>rkdname.zj"+
" AND ie.CURR<>rkdname.bzsname"+
" AND ie.COUNTRY<>rkdname.sgov"+
" AND ie.UNIT<>rkdname.units";

[lydong]

把SQL打印出来，在数据库命令行窗口执行，用排他法逐步确定错误原因

？错误代码

[silverend]

语法细节得小心

[wcmj]

"rkdname.invoice_no AS invoice_no"+ 少了","

[wenchaohu213]

语句一条一条的执行，

就知道问题到底是处在哪一条的语句上面了

[alpha15]

"rkdname.invoice_no AS invoice_no********************"+
"rkdname.invoice_date AS invoice_date,"+

[linhao315]

SELECT rkdname.ywid AS ywid,"+ 少了引号"
应为：
SELECT "rkdname.ywid AS ywid,"+

[韩嵩峰]

顶!!!!

[hcw_peter]

"rkdname.invoice_no AS invoice_no"+
少了个逗号。
这段sql运行起来效率不回太高，用了两个in语句。
其实可以整合一下，把最后那个in中的sql用关联的方式，会快一些。