Hello, friends. You have been always such a great help. Please, help me with another problem. I have a table1(value1,value2,value3,date). Combination of (value1,value2) is a primary key, but it wasn#%92t set up. I have duplication of combination (value1,value2) records with value3 and date being different. I would like to keep only one record and delete the second one with the earlier date. Table1 look like it: a b c date a b c1 date1 --should be deleted a1 b1 c date a1 b1 c1 date1 --should be deleted a2 b2 c date a2 b2 c1 date ----should be deleted Thanks again for your help. Alex.