UPDATE USER_BOTS SET strSkill = ( SELECT strSkill FROM USERDATA WHERE strUserID = 'Warrior' ) WHERE Class in (101,105,106,201,205,206)
UPDATE USER_BOTS SET strSkill = ( SELECT strSkill FROM USERDATA WHERE strUserID = 'Rogue' ) WHERE Class in (102,107,108,202,207,208)
UPDATE USER_BOTS SET strSkill = ( SELECT strSkill FROM USERDATA WHERE strUserID = 'Mage' ) WHERE Class in (103,109,110,203,209,210)
UPDATE USER_BOTS SET strSkill = ( SELECT strSkill FROM USERDATA WHERE strUserID = 'Priest' ) WHERE Class in (104,111,112,204,211,212)