Hi,
I want to update the balance field from the client table from the result of a query (This query calculates the balance (accounts.amount_due - accounts.amount_paid) and selects all clients which are are disconnected (client.disconnected=false))
How do I do this? Thank you :)