This SQL creates a list of number of points within each polygon: select polygon.polyID, Count(*) from polygon, point where polygon.Obj Contains point.Obj group by polygon.polyID into temp
You will need a second SQL to select only some of them: select polygon.polyID from polygon, temp where polygon.polyID=temp.polyID and temp.COL2>1 Kind regards Uffe Kousgaard www.routeware.dk ----- Original Message ----- From: "Peter Hatton" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, June 12, 2003 3:16 AM Subject: MI-L MULTIPLE POINT SQL > > Hi all, > Wondering if someone can help me with the > following SQL. > I would like to be able to perform an SQL > so that I can find all polygons within my table that have multiple point > objects within that polygon.I can do an SQL to find all the polygons with > one point object but I wish to find all with more than one point object. > > Many thanks > Peter > > Peter Hatton > GIS Officer > GREATER TAREE CITY COUNCIL > PO BOX 482 TAREE NSW > Phone 02 6592 5227 > E-mail [EMAIL PROTECTED] > > --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 7246
