I have a table containing thousands of point locations which represent Water Well Locations, the Well in the following format:
WellID Easting Northing DepthFrom Depthto 0001 50000 400000 250 240 0001 50000 400000 240 220 0001 50000 400000 220 210 0002 50050 400025 265 255 0002 50050 400025 255 230 etc... What I need to do is extract from this table the records with the highest DepthFrom value. So I would end up with this table after running my query: 0001 50000 400000 250 240 0002 50050 400025 265 255 Is there any easy way to achieve this using SQL select or select, or do I have to create a piece of code for this? I should add that I'm very green with MI 7.0 and haven't looked into MapBasic at all. Regards, BChrisCo --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 11672
