Hi David
The trick is to use an subselect.
Try this SQL:
Select * from MyPointTable where not obj within any (Select Obj from
myRegionTable)
Peter Laulund
National Survey and Cadastre, Denmark
"David McDonald" <[EMAIL PROTECTED]> - 27-07-99 01:14:31
Besvar venligst til "[EMAIL PROTECTED]"
<[EMAIL PROTECTED]>
Til: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>
cc: (bcc: Peter Laulund/MI/KMS)
Vedr�rende: MI Geographic Operators
This may be an obvious question to some!
Is there a geographic operator for selecting points "outside" of regions.
I thought you could use "Not Within" or similar, but this does not seem to
work.
ie "Point.Obj Not Within Region.Obj"
All the listed operator commands seem to based on being within another
object and none seem to relate to being outside.
Can someone please help?
Regards,
*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*
* DAVID McDONALD *
* Senior Technical Officer / GIS Co-ordinator *
* BC Tonkin & Associates, Consulting Engineers *
* 55 Queen Street, Adelaide, SA, 5000, Australia *
* Ph: +61 8 8223 5583 Fax: +61 8 8223 5237 *
* E-mail: [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]
