SQL Help: Linking NPC ID to zoneid
 

ok, trying to create a SQL statement that will link a NPC to their zone #(because i really want the expansion column in the zone table)

Maybe i'm too excel but tried

Select a.name, b.expansion from npc_types a, zone b where b.zoneidnumber = left(a.id,length(a.id) - 3)) and length(a.id) > 3

SELECT nt.name, s2.zone
FROM spawn2 s2
JOIN spawngroup sg
ON sg.id = s2.spawngroupid
JOIN spawnentry se
ON se.spawngroupid = sg.id
JOIN npc_types nt
ON nt.id = se.npcid
WHERE s2.zone = 'crushbone';