> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Adi
> Sent: June 19, 1999 2:23 AM
> I have two tables, one has point attributes (city location )and second has
polygon state boundaries), I want to select the name of the state boundary
based on a given city name (point name).
> Select * from state, city where state.obj contains city.obj and
> city.name = "Name" into name_found
> It takes too much of time,
...
I think that the order of the "where" conditions is important. The first
condition of the set is verified than the second is applied,... That would
mean that all the cities are first selected because they are all in a state,
then they are checked by name.
I suggest that
where city.name = "Name" and city.obj within state.obj
should be more efficient.
But this is pure logic and logic gas been defeated so often with MB/MI that
???
Jacques Paris
============================================================
e-mail [EMAIL PROTECTED]
alternate [EMAIL PROTECTED]
gis activity (MapInfo mainly)
http://www.total.net/~rparis/gisproducts.htm
============================================================
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
