Whoops, there's an error in my post in the Where section of the SQL wizard, it should be-
Where: Point.Obj Within Mytable.Obj William "Woody" Woodruff Zoning Administrator Charter Township of Union, Isabella County, Michigan -84.80947000 43.61095100 2010 S Lincoln Rd, Mt. Pleasant, MI 48858 (989) 772 4600 EXT 41 Visit our web site at http://www.geocities.com/ctuzoning/index.htm -----Original Message----- From: Woody Woodruff [mailto:[EMAIL PROTECTED] Sent: April 18, 2004 08:41 To: Craig, Fergus; [EMAIL PROTECTED] Subject: RE: MI-L Polygon query MyTable is the region table, Point is the point table Select Mytable.ID, CentroidX(Point.obj),CentroidY(Point.obj) from Point, Mytable where Point.Obj Within Mytable.Obj into Selection By SQL Wizard By Columns: Mytable.ID, CentroidX(Point.obj),CentroidY(Point.obj) >From Tables: Point, MyTable Where: Mytable where Point.Obj Within Mytable.Obj Group By: blank Order By: MyTable.ID if you like Into: (Default) Selection or any able name you wish William "Woody" Woodruff Zoning Administrator Charter Township of Union, Isabella County, Michigan -84.80947000 43.61095100 2010 S Lincoln Rd, Mt. Pleasant, MI 48858 (989) 772 4600 EXT 41 Visit our web site at http://www.geocities.com/ctuzoning/index.htm -----Original Message----- From: Craig, Fergus [mailto:[EMAIL PROTECTED] Sent: April 15, 2004 09:49 To: [EMAIL PROTECTED] Subject: MI-L Polygon query Dear All, I have a table of points and a table of polygons, I want to create a query that will produce a table with the point co-ordinates matching up with the ID of the polygon they fall into. Thanks in advance, Fergus. --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 11398 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 11450 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 11452
