擅长:python、mysql、java
<p>SQLCommand每行之间缺少空格,这可能会触发错误。我在第2行到第5行的“后面加了空格。在</p>
<pre><code>SQLCommand =("SELECT DISTINCT CONCAT(RMORHP.ORHCUSCHN, '-', RMORHP.ORHCUSNUM) As 'Customer Number', RMCUSP.CUSCUSNAM As 'Customer Name', RMORHP.ORHDELDTE As 'Delivery Date', Count(RMORHP.ORHORDNUM) As 'Order Count'"
" FROM BIDW_DataLake.erms.RMORHP RMORHP, BIDW_DataLake.eRMS.RMCUSP RMCUSP"
" WHERE (RMORHP.ORHDELDTE Between 20181010 And 20181011) AND RMORHP.ORHORDQTY > 0 AND RMCUSP.CUSCUSCHN = RMORHP.ORHCUSCHN AND RMCUSP.CUSCUSNUM = RMORHP.ORHCUSNUM AND RMCUSP.CUSDFTDCN = 505"
" GROUP BY CONCAT(RMORHP.ORHCUSCHN, '-', RMORHP.ORHCUSNUM), RMCUSP.CUSCUSNAM, RMORHP.ORHDELDTE"
" ORDER BY [Delivery Date], [Customer Number]")
</code></pre>