The right way to do this in SQL is the use of the "Having" clause, which MapInfo does not support. You could select those records with >=2 records as a second query, or create a contrived nested query in the SQL window. Maybe this is something they will fix in the next release?
-- Steve -----Original Message----- From: Wendy Tam [mailto:[EMAIL PROTECTED] Sent: Thursday, July 08, 2004 10:10 AM To: Map Info List (E-mail) Subject: MI-L Using "Count" in MapInfo V5 Query? Hi, Is there a way I can incorporate the SQL "count" with a MapInfo V5 query? I need to return points within a region only if there are two are more points in that region. In the "WHERE" condition, I have already specified to return the objects that are within a region, but I need to restrict it so that only points that exist in a region with at least one other point are returned. Thank you for your time, Wendy --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 12515 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 12516
