[vkrr]

Hey, I am trying to disable journeyman mercs.

This is my fake sql / what I intend to do

select * from merc_npc_types where proficiency=2 (or name like '%journeyman%')
out of that subset compare  merc_npc_types.merc_npc_type_id to merc_templates.merc_template_id
if they match set merc_templates.clientversion=1024

my SQL scripting ability is miserable. I know this isn't right but I can't quite get it.

update merc_templates set clientversion=1204 where 


merc_npc_types.merc_type.id
from
  merc_npc_types
left outer join
  merc_templates
on
 merc_npc_types.merc_type.id = merc_templates.merc_template_id
where
   merc_npc_types.proficiency=2

or I could do this but it still doesnt set it in the merc_template section

update merc_types set clientversion=1024 where proficiency_id=2;