Hello All !!!
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).
I am trying it with MB, when I write sql for that like below
Select * from state, city where state.obj contains city.obj and city.name = "Name"
into name_found
It takes too much of time,
When I say
Select * from state, city where state.obj contains city.obj (select name from where
NAME = "NAME")
OR
select name from where NAME = "NAME" INTO ABC
AND
Select * from state, ABC where state.obj contains A.OBJ
It gives me error that you can perform join on base tables onle., if I commit then it
allows me to
do so.
It means I will have to commit that table first to join, but is there any other way ?
Thanks in advance
===================================================
Aditya
Executive (Systems)
Information Systems Department
GCMMF, Anand
E-mail me at Mailto:[EMAIL PROTECTED]
Web Site: http://www.amul.com
===================================================
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
