SELECT A.OLD_INVOICE_NO INV_NO, A.DESPATCH_DATE, ROUND(SUM(B.NET_WT/1000),2) QTY_MT FROM SALES.SALES_EXPORT_INVOICE_MASTER A, SALES.SALES_EXPORT_INVOICE_QUALITY B WHERE B.DESPATCH_CODE = A.DESPATCH_CODE AND B.COMP_CODE = A.COMP_CODE AND A.FINAL_INVOICE_AMT IS NOT NULL AND A.DESPATCH_DATE BETWEEN :FDATE AND :TDATE AND A.COMP_CODE = 3 GROUP BY A.OLD_INVOICE_NO, DESPATCH_DATE ORDER BY A.OLD_INVOICE_NO, DESPATCH_DATE