Ciao ragazzi!!
Sapete dirmi il perchè questa query cosi' funziona:
QUERY_ORACLE = "SELECT PDCD_CODPROD,PDCD_POSFIS,SUM(PDCD_QTARIC_KG),PDCD_DENS15,SUM(PDCD_QTACON_LT15),(SELECT PFIS_DESFIS FROM ""M6.TBL_POSFIS"" WHERE PFIS_CODPROD=PDCD_CODPROD AND PFIS_POSFIS=PDCD_POSFIS) FROM ""M6.TBL_PDC_D"" WHERE PDCD_DATACONS=TO_DATE('" & DataElab & "','DD/MM/YYYY') AND (SELECT PDCT_STATO FROM ""M6.TBL_PDC_T"" WHERE PDCT_NUMPDC=PDCD_NUMPDC AND PDCT_DATACONS=PDCD_DATACONS)='3' GROUP BY PDCD_CODPROD,PDCD_POSFIS,PDCD_DENS15"
e cosi invece non mi restituisce niente:
QUERY_ORACLE = "SELECT PDCD_CODPROD,PDCD_POSFIS,SUM(PDCD_QTARIC_KG),PDCD_DENS15,SUM(PDCD_QTACON_LT15),(SELECT PFIS_DESFIS FROM ""M6.TBL_POSFIS"" WHERE PFIS_CODPROD=PDCD_CODPROD AND PFIS_POSFIS=PDCD_POSFIS) FROM ""M6.TBL_PDC_D"" WHERE PDCD_DATACONS=TO_DATE('" & DataElab & "','DD/MM/YYYY') AND PDCD_TIPO_DOCFISC <> '1' AND (SELECT PDCT_STATO FROM ""M6.TBL_PDC_T"" WHERE PDCT_NUMPDC=PDCD_NUMPDC AND PDCT_DATACONS=PDCD_DATACONS)='3' GROUP BY PDCD_CODPROD,PDCD_POSFIS,PDCD_DENS15"
io ho aggiunto nella seconda query:
AND PDCD_TIPO_DOCFISC <> '0'
Ciao Grazie!!