Hi, No. I can DO that... but I'm referring to using Informix/SpatialWare. I'm trying to peform SQL to do that. I am well aware of the manually doing it. Thanks! I'm creating a series of projects for teaching students about Informix/SpatialWare at my university. -Erick -- Erick Posner Join AllAdvantage! Earn $ while you surf anywhere on the Web http://www.alladvantage.com/go.asp?refid=cbl286 ----- Original Message ----- From: Jason Adam <[EMAIL PROTECTED]> To: Erick Posner <[EMAIL PROTECTED]> Sent: Thursday, April 13, 2000 4:50 AM Subject: RE: MI Help with UNION Erick- I think you can do this by selecting both polygons, then Objects>Combine. You will be presented with a list of your columns to specify whether to add them together, choose a specific value, or the average of the two. Jason ���������������������� Jason Adam Computer Draftsperson Monopros Limited Toronto, ON [EMAIL PROTECTED] > -----Original Message----- > From: Erick Posner [SMTP:[EMAIL PROTECTED]] > Sent: Wednesday, April 12, 2000 6:04 PM > To: [EMAIL PROTECTED] > Subject: MI Help with UNION > > Hi, > > I'm trying to perform Informix/Spatialware query that will merge two rows > into one row. > > I have a file called Flood100. In that file, there's two records that was > supposed to be one record. I'm trying to merge both polygons into one > polygon using SQL (Informix/Spatialware). I have tried using Union > statement to no avail. > > Any suggestion? > > -- > Erick Posner > Join AllAdvantage! Earn $ while you surf anywhere on the Web > http://www.alladvantage.com/go.asp?refid=cbl286 > > > ---------------------------------------------------------------------- > To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put > "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED] ---------------------------------------------------------------------- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
