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