mass moving members from one group to another without an active subscription

[StEaLtH666]

hi,

I currently run a large forum, and over the years and just recently we are trying to change our set-up.

However we have around 1000 members or more who don't have an active paid subscription in the group we also have our monthly paid subscribers.

I'm looking for a way to move all these members in one foul swoop from say group a to b, but don't have an active subscription.

I'm guessing it may be an sql query to run, but i am not that competent in sql and was wondering if anyone could lead me in the right direction please

Many thanks