Hi Tim
In SQL just use the operator "within" on the obj-attributes such as "parcel.obj within
neighbourhood.obj" ...
Regards
Flavio
*********** REPLY SEPARATOR ***********
On 27.06.2000 at 09:52 Tim Smith - Parks Dept wrote:
>Hello MI people!
>
>I know this is a rather elementary query, but I'm a neophyte MI user (and a
>mere ecologist, at that!) and I can find no insight in the manuals or
>on-line help.
>
>I have data layer of about 650 open space parcels within our city. The
>table contains no fields denoting which neighborhood each parcel is in. I
>have another table outlining each of 18 neighborhoods. That table contains
>just the neighborhood name and a code number. I can easily combine the two
>layers in a map window and see which parcels are in which neighborhoods. I
>would like to create a new browser, joining the two tables. The overall
>goal is to export the table to EXCEL and be able to sort the parcels based
>by neighborhoods. I have tried to join the tables using SQL QUERY/"where
>condition....", but there are no common fields to base the join on. Is
>there a way to select only the parcels that are occuring in a given
>neighborhood?
>
>Thanks in advance for any insight.
>
>************************
>Tim Smith
>Urban Wilds Project Manager
>Boston Parks
>617-635-4505, ext. 6511
>617-635-3256, fax
>************************
>----------------------------------------------------------------------
>To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
>"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
!!! See our new Mapping Server under http://www.mapserver.ch !!!!
-----------------------------------------------------------------
############ Mit freundlichen Gruessen / Kind Regards
############ Flavio Hendry- mailto:[EMAIL PROTECTED]
############ TYDAC AG - http://www.tydac.ch
#### #### Geographic Information Solutions
#### #### Buristrasse 23 -- CH-3006 Bern
############ Tel +41 (0)31 368 0180 - Fax +41 (0)31 368 1860
-----------------------------------------------------------------
MAPINFO Strategic Partner - PCI Reseller - FME Distributor
-----------------------------------------------------------------
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
