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]
