Christy,
In answer to your first question,
Select * from YourTable where ObjectInfo(obj,21) > 1
should work. ('21' is the integer value for OBJ_INFO_NPOLYGONS define in the
Mapbasic.def)
Keith
-----Original Message-----
From: Christy Noonan [mailto:[EMAIL PROTECTED]]
Sent: 01 June 2001 15:07
To: MapInfo-L (E-mail)
Subject: MI-L MI: SQL to select records with multiple polygons
Mappers,
I would like to be able to select all the records in a table that have more
than 1 polygon associated with that record. Can anyone help with an SQL
that pulls out the number of polygons in a record?
OR
Be able to select all the records in a table that have duplicate zip code
records in the table. However, 'grouping' does not work b/c it only keeps 1
row (and the fields or only one record).
Thanks in advance for any help you can provide,
Cn
_______________________________________________________________________
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.
This email and any attached files are confidential and copyright protected.
If you are not the addressee, any dissemination of this communication is
strictly prohibited. Unless otherwise expressly agreed in writing, nothing
stated in this communication shall be legally binding.
_______________________________________________________________________
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.
