I have the old Oracle 8 database that I am trying to get some data off but I can't quite get the query right.
SELECT TO_CHAR(TRANSACTION0.DOCUMENT_DATE, 'YYYY-MM') AS MyDate, TRANSACTION0.FK_TRANSMISSIONFK, TRADING_PARTNER.NAME,
TRANSACTION0.DOCUMENT_NAME, TRANSACTION0.DOCUMENT_ID...