Re: GROUP BY Destroys 2nd Function

2005-10-28 Thread David Blomstrom
--- [EMAIL PROTECTED] wrote: > <<<>>> > > David, is it at all intuitive to organize your > geography into a tree-type > structure? Here is an example: > > Western Hemisphere (hemisphere) > C. America (continent) > Guatemala (country) > N. America (continent) >

Re: GROUP BY Destroys 2nd Function

2005-10-28 Thread SGreen
<<<>>> David, is it at all intuitive to organize your geography into a tree-type structure? Here is an example: Western Hemisphere (hemisphere) C. America (continent) Guatemala (country) N. America (continent) Canada (country)

Re: GROUP BY Destroys 2nd Function

2005-10-28 Thread David Blomstrom
--- Jigal van Hemert <[EMAIL PROTECTED]> wrote: > > ANIMALS TABLE > > Canis_lupus | wolf > > Panthera_tigris | tiger > > > > JOIN TABLE > > SPECIES | ECOREGION > > Canis_lupus | NA1008 > > Canis_lupus | NA1010 > > > > ECOREGIONS TABLE > > ID | NAME | Geog | Geog2 > > NA1008 | Alaska tundra | na

Re: GROUP BY Destroys 2nd Function

2005-10-28 Thread Jigal van Hemert
David Blomstrom wrote: I have a PHP script that displays data like this: Eurasia Eurasiaisland Africa Where Eurasia and Africa are mainland parents of ecological regions and Eurasiaisland is a parent of an ecological system that is associated with a continent. For example, Borneo would be Eurasi

GROUP BY Destroys 2nd Function

2005-10-28 Thread David Blomstrom
I have a PHP script that displays data like this: Eurasia Eurasiaisland Africa Where Eurasia and Africa are mainland parents of ecological regions and Eurasiaisland is a parent of an ecological system that is associated with a continent. For example, Borneo would be Eurasiaisland. The finished s