you could go even furthre and use
Select censusblockID, wirelesscentreID,
PropoertionOverlap(censusblock.obj,wireless.obj)
from censusblock, wirelesscentre
Where censusblock.obj intersects wireless.obj
Order By censusblockID, wirelesscentreID
Into Areas
To give you not only a list of all intersecting boundaries in both files,
but the proportion of each cencsusblock that is covered by the
wirelesscentre.
Hope your data is clean though as this type of query will often produce
overlay errors if it is not.
Rob
-----Original Message-----
From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent: Friday, December 03, 1999 6:12 AM
To: Mike C Kallas
Cc: [EMAIL PROTECTED]
Subject: Re: MI Within AND Intersect
>Can't seem to get a result set I want.
>I have a Census Block boundary file and a WireCenter boundary file and I
>want to select all the Census Blocks that each Wirecenter boundary
>touches. I need everything inside and all Census Block boundaries the
>Wirecenter interesects.
I don't know what you've tried, but if you have tables census_blocks and
wire_centers, then you can select all the census blocks that are inside
and intersect a wire center with the ID of xyz with this SQL statement.
Select * From census_blocks Where Obj Intersects
(Select Obj From wire_centers Where ID = "xyz")
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
