Hi all,
I have a table as follows (example):
ID Dist ID_2
1 20 102
1 24 103
1 45 111
I want to create a table that only contains the ID, minimum DISTvalue
and associated ID_2 value.
For example, new table ONLY contains the row of info:
ID Dist ID_2
1 20 102
and disregards the other 2 rows.
Can this be done easily. I have about 80,000 records in the database.
Regards
Tony
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
