Go to Table > Update Column and fill in the appropriate fields: If you open a mapbasic window first, the result should look like this: Add Column "polygontable" (countfield) From pointtable Set To Count(*) Where within
Kind regards Uffe Kousgaard www.routeware.dk ----- Original Message ----- From: "Christian McNierney" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, March 18, 2002 9:17 PM Subject: MI-L SQL Select > I have two tables, one contains points, the other polygons. I want to > find out how many points are within each of the polygons and update that > count in the polygon table. I'm drawing a blank on this one. > > Thanks, > > Christian McNierney > > > > Spatial Insights, Inc. > > A Geographic Information Services Company > > 8221 Old Courthouse Road Suite 203 Vienna, VA 22182 > > Tel: 703-827-7036 Fax: 703-827-7037 > > Sales: 800-347-5291 > > [EMAIL PROTECTED] www.spatialinsights.com > > > > > > _______________________________________________________________________ > List hosting provided by Directions Magazine | www.directionsmag.com | > To unsubscribe, send e-mail to [EMAIL PROTECTED] and > put "unsubscribe MapInfo-L" in the message body. > _______________________________________________________________________ List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MapInfo-L" in the message body.
