SeraphicHQ

-- all the columns and format which you need for purchasing and other related stuff
SELECT * FROM
    (select
      DATE_FORMAT(mt.PURCH_INVOICE_DATE, "%d-%b-%Y") as PURCH_INVOICE_DATE,
    mt.DOCUMENT_NO DOC_NO,
    sup.SUPPLIER_CODE,
    sup.COMPANY_NAME,
    itm.ITEM_CODE,
    itm.ITEM_DESC,
    det.PRIMARY_QTY qty,