MapInfo Calculating the number of Points that Fall within a Boundary

Question

I have two layers in MapInfo (points and polygons). I need to select points which fall within polygons where the income > 1500

I tryed this one but not working: http://www.sgsi.com/MIUserGroup/imgs/sql1.jpg

I also tryed this SQL code but doesn't work: points.Obj Within polygon.Obj where income > 1500

Any idea?

Answer 1

The where condition you are looking for is:

points.Obj Within polygon.Obj AND polygon.income > 1500

You can also solve the problem by using a sub select query instead of a join query. Here is how to fill in the details in the SQL Select dialog:

Select: *

From: POINTS

Where: OBJ Within Any (Select OBJ From POLYGON Where INCOME > 1500)

Or in a Select expression it would look like this:

Select *
From POINTS
Where OBJ Within Any (Select OBJ From POLYGON Where INCOME > 1500)