Akua
Perhaps you
could try:
Where not (CT2000.obj intersects BranchesBuffer.obj)
Iy might be useful if you include the FULL SQL select
you used as, given what you supplied, I can't immediately see any fault with it
that would cause the error.
Terry
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]
Sent: 17 March 2006 22:01
To: Terry McDonnell
Subject: RE: [MI-L] Query for determining Entirely Within/Outside of Buffer
Thank you soooo much Peter and Terry!
I tried it out and have no problems with getting the tracts that
are entirely within or partly within, but when I get to querying objects "Not Partly Within" (Entirely Outside)
I keep getting the error message:
"No Join Specified between tables, Invalid Join Condition in Where Clause" and
I cannot figure out what the problem is.
The tables I have are called: CT2000 and BranchesBuffer
This is what I enter:
1) Where not CT2000.obj Partly Within Any BranchesBuffer.obj
and after this didn't work I tried
2) Not (CT2000.obj Partly Within BranchesBuffer.obj)
and I still got an error message. Any suggestions?
Thanks!
Akua
_______________________________________________ MapInfo-L mailing list [email protected] http://www.directionsmag.com/mailman/listinfo/mapinfo-l
