UBB.threads PHP Forum Software Community Forums UBB.threads Version 7/8 Support mass change titles

I want to change all the users in a specific group to a specific title..

Can anyone give me the specific SQL to do this change. Based on the database there will have to be a few joins to accomplish it.

Thanks in advance

Just in case anyone else wants to to a mass title change:

update ubbt_USER_PROFILE u, ubbt_USER_GROUPS g
SET u.USER_CUSTOM_TITLE = 'xyz'
where g.GROUP_ID = '9'
and u.USER_ID = g.USER_ID;