[Irreverent]

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