Thread: Matching grid zoneID with zone names
View Single Post
  #2  
Old 06-28-2006, 02:21 AM
GeorgeS
Forum Guide
  
Join Date: Sep 2003
Location: California
Posts: 1,474
Default
SELECT id,type,type2,long_name FROM grid,zone WHERE (grid.zoneid=zone.zoneidnumber)


and then run this

SELECT gridid,number,x,y,z,heading,pause,long_name FROM grid_entries,zone WHERE (grid_entries.zoneid=zone.zoneidnumber)

GeorgeS
__________________
Your source for EQ database tools
Toolshop is open for business


http://www.georgestools.chrsschb.com//
Reply With Quote