RE: Duplicate Records

insert into new_table select unique <list_of_fields_except_vendor> fromold_table beware of long transaction and lock overflow. > -----Mensaje original----- > De: Libi Maniace [SMTP:lmaniace@beissd.com] > Enviado el: Lunes 27 de Noviembre de 2000 10:19 AM > Para: List Informix (E-mail) > Asunto: Duplicate Records > > Help... > > Is there an easy way to delete duplicate records within a table. > I have a table that has item, vendor and last purchase date and cost. > If we happen to buy that item from two vendors it creates two records. > I am trying to consolidate the item cost into a single table by > item number eliminating the vendor part. Any ideals on how to do this > easily? > > Thanks > > Libi