c#對SQL有特別要求嗎?
為什么我下面這個SQL放到C#中﹐就說沒有資料呢?可我放到Oracle資料庫中卻有800多筆呢?是不是c#對SQL有什么特別的要求?
SQL:
------------------
SELECT X.YM,X.CUST_NAME,X.ODR_NO,X.STYLE_NAME,X.ODR_QTY,X.TOT_QTY,Z.TOT as hhhhh,'odr_no='||X.ODR_NO||'&'||'style_no='||X.STYLE_NO AS ARG FROM (select substr(A.pro_date,0,6) as ym,C.CUST_NAME,A.ODR_NO,D.STYLE_NO,D.STYLE_NAME,NVL(SUM(A.odr_qty),0) odr_qty,nvl(sum(tot_pro_qty),0) tot_qty from odr_prom A,ODRM B,CUSTOM C,STYLEM D where A.ODR_NO=B.ODR_NO AND B.STYLE_NO=D.STYLE_NO AND B.CUST_NO=C.CUST_NO AND A.FAC_NO='R0' AND A.DEPT_NO='R2' AND substr(pro_date,0,6)='200309' GROUP BY substr(A.pro_date,0,6),A.odr_no,C.CUST_NAME,D.STYLE_NO,D.STYLE_NAME) X, (SELECT ODR_NO,NVL(SUM(TOT_PRO_QTY),0) AS TOT FROM ODR_PROM WHERE FAC_NO='R0' AND DEPT_NO='R2' GROUP BY ODR_NO) Z WHERE X.ODR_NO=Z.ODR_NO
----------------------
謝謝!
fans