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

2005-03-28 03:55:04 222 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

九度OJ题目1100-最短路径题目描述： N个城市，标号从0到N-1，M条道路，第K条道路（K从0开始）的长度为2^K，求编号为0的城市到其他城市的最短距离输入：第一行两个正整数N（2<=N<=100）M(M<=500),表示有N个城市，M条道路接下来M行两个整数，表示相连的两个城市的编号输出： N-1行，表示0号城市到其他城市的最短路，如果无法到达，输出-1，数值太大的以MOD 100000 的... 阅读详情

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";

...全文