select points.obj
from table
where points.obj not within region.obj
or (points.obj within regions.obj and region.CLLI <> points.CLLI);
Try this.
On Wed, 19 Apr 2000, ANDREW MCMILLAN wrote:
> Hello everyone,
>
> Just wondering if anyone could help me with a query
> in MapInfo. The two parts of the OR statement work
> individually but when combined, I recieve and error.
>
> QUERY:
> (select all points.obj that fall outside of a
> region.obj) or (select all points.obj that fall within
> region.obj where points.fieldA does not equal
> region.fieldA)
>
> SQL SELECT:
> (not obj within any (select obj from region))
> or(points.obj Within region.obj and
> region.CLLI<>points.CLLI)
>
> ERROR:
> No Join Specified Between Tables....
>
> Can anybody please explain how to make this query
> work. I'm stumped....
>
> TIA
>
> =====
> ���`����,��,����`�������`����,��,����`��������`
> Andrew McMillan ,,, (905)433-3418(W)
> GeoSolutions- ActiMedia /'^'\ (905)985-3518(H)
> Oshawa, ON, Canada ( o o )(905)259-3515(C)
> --------------------oOOO--(_)--OOOo-----------
> email: [EMAIL PROTECTED]
>
> _______________________________________________________
> Do You Yahoo!?
> Get your free @yahoo.ca address at http://mail.yahoo.ca
> ----------------------------------------------------------------------
> To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
> "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
>
-----------------------------------------------------------------
Erick Posner
-----
"My Mom said she learned how to swim. Someone took her out in the lake
and threw her off the boat. That's how she learned how to swim. I said,
'Mom, they weren't trying to teach you how to swim.' "
--Paula Poundstone
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
