SELECT B.SALE_NO,A.OLD_INVOICE_NO INVOICE,A.DESPATCH_DATE IDATE,C.ABBR_NAME BUYER,A.PORT_OF_DISCHARGE PORT,A.SHIPMENT_TYPE VESSEL,
D.OLD_CODE QUALITY,B.DESPATCH_QUANTITY QUANTITY ,B.DESPATCH_QUANTITY_UNIT  
FROM SALES.SALES_EXPORT_INVOICE_MASTER A,SALES.SALES_EXPORT_INVOICE_QUALITY B,MREL.MREL_SALES_BUYER_MAST C,
MREL.MREL_PRODUCT_MASTER D
WHERE A.DESPATCH_CODE = B.DESPATCH_CODE
AND A.COMP_CODE = B.COMP_CODE
AND A.BUYER_CODE = C.BUYER_CODE
AND B.PRODUCT_CODE = D.PRODUCT_CODE
AND B.QTY_CODE IN (37,38)
AND A.DESPATCH_DATE BETWEEN '01-MAR-2010' AND '21-MAY-2010'
ORDER BY 2