Howdy, I need to close customer accounts for a large number of customers approx 2500 were created with a default charge account before I realized what was happening. These customers have never used their accounts and I want to close them I have a few customers who do use them and are carrying balances...
I need help with a SQl statemment to
1) select customers who have accounts with $0 balances
2) Change the account type to "none"
any help appreciated
thx