[bad_captain]

This should work.

UPDATE merc_templates SET clientversion = 1024 
WHERE merc_npc_type_id IN 
    (SELECT merc_npc_type_id FROM merc_npc_types WHERE proficiency_id = 2)