Thanks to everyone for their suggestions.
Thanks especially to David M Haycraft whose code worked perfectly (shown
below)
Select *
>From PointTab
Where not (PointTab.Obj within any (Select Obj from RegionTab))
Most other suggestions like "Not Point.Obj Within Region.Obj" caused
MapInfo to reply "No Join specified between tables. Invalid join condition
in WHERE clause". This was strange because the syntax was checked and said
to be correct.
Thanks once again David M Haycraft (and thanks to Peter Laulund who was
also on the right track)
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]