PDA

View Full Version : Matching grid zoneID with zone names


Angelox
06-28-2006, 12:24 AM
Is it possible to match "zoneid" number in "grid" and "grid_entries" with the proper zone name? If so how would I do that?

Thanks

GeorgeS
06-28-2006, 02:21 AM
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