MI SQL Select Problem

2000-04-19 Thread ANDREW MCMILLAN
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

Re: MI SQL Select Problem

2000-04-19 Thread Colonel Erick Posner
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