>From SQL select, found how many each Select ID, Count(*)"occurance" from YOUR_TABLE group by ID into query_link
>From Select from query_link where occurance > 1 into table_of_multiple - SAVE table_of_multiple (because you will need to make a link and it's only possible on base table) - Close it to remove from memory - Open table_of_multiple (base table) >From SQL select, Select * from YOUR_TABLE, table_of_multiple where YOUR_TABLE.ID = table_of_multiple.ID into objet_with_multiple_id Browse * From objet_with_multiple_id You now have selected all the object from you table selected. You may want to delete, cut and paste it in other table, update the column id, etc GH -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: December 12, 2003 06:00 To: [EMAIL PROTECTED] Subject: MI-L Deleting same ID's Dear all I have a table with 40'000 records. In there are records which have three or more times the same ID. I need only one record of the same ID. How could I delete the others by using a query? Thank you for providing me with the appropriate solution. With kind regards C. Cattaneo christian cattaneo Bundesamt für Verkehr BAV Bollwerk 27/29 CH-3003 Bern e-mail: [EMAIL PROTECTED] oder [EMAIL PROTECTED] tel: +41 31 325 12 78 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 9544 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 9550