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