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]

Reply via email to