SELECT invoice_receivables.date_received, invoice_receivables.received_curr, invoice_receivables.amount_received, invoice_per_client.licensee, invoice_per_client.invoice_id & '/' & invoice_per_client.year AS invoice_id, invoice_per_title.item, bank.bank_name
FROM invoice_receivables LEFT JOIN ((bank RIGHT JOIN invoice_per_client ON bank.bank_id = invoice_per_client.bank_id) RIGHT JOIN invoice_per_title ON invoice_per_client.invoice_id = invoice_per_title.invoice_id) ON invoice_receivables.link4 = invoice_per_title.link4
ORDER BY invoice_receivables.date_received;