inv connected to address to client,
payment connected to inv
My output will be
client reference idinvoice idpayment amount
I inserted some sample data above, but on posting, it strays into another column. The sequence is right though.
inv.total is to be in the same column as payment.amount AS amount negative.
datetime and pdatetime under same column as time.