[Trig]

Ok any of you clever guys and girls out there know what sql command would bring back the following with this scenario.

eq.npc_types (ID, name) [Where ID =eq.spawnentry(NPCID)
eq.spawnentry (spawngroupID, NPCID)
eq.spawn2 (spawngroupID, Zone)

now with that information in mind (yes i realise they have other fields as well but from what i can tell those are the pertinent ones) what would the SQL command be (if possible) to return:

eq.spawn2's zone=>spawngroupid associated and displayed directly alongside the appropriate information in eq.npc_types?

Any ideas?

Trig