QODBC query to find invoices with duplicate RefNumbers
use:
select
a.RefNumber, a.CustomerRefFullName, a.TimeCreated
from Invoice a, Invoice b
where a.RefNumber = b.RefNumber
and a.TimeCreated <> b.TimeCreated
and ( a.TxnDate > {d'2021-09-21'} or b.TxnDate > {d'2021-09-21'} )