Final, working query:
Code:
UPDATE loottable INNER JOIN npc_types ON loottable.id=npc_types.loottable_id INNER JOIN spawnentry ON npc_types.id=spawnentry.npcID INNER JOIN spawn2 ON spawnentry.spawngroupID=spawn2.spawngroupID SET loottable.mincash = 0, loottable.maxcash = 0, loottable.avgcoin = 0 WHERE spawn2.zone = 'ruji';
-Hate