Hi,
Is it possible to do subqueries when connecting to Sage 50 via ODBC connection?
I would like to do something like:
SELECT AUDIT_HEADER.INV_REF, AUDIT_HEADER.DETAILS, AUDIT_HEADER.DATE, AUDIT_HEADER.DUE_DATE, AUDIT_HEADER.NET_AMOUNT, USAGE.AMOUNT…