Hi all,

I have problem trying to update one record where there may be more than one entry for a given date.

RID EmpID Reason Date
1 2 Good 2007-09-10
2 2 Nice 2007-09-10
3 1 Good 2007-09-10

There are two tables involved selection and employee empid is from employee table and is the fkey. I will to only update one of the records without specifying the RID. Update on single value ignoring any duplicates

Jaime E. Maccou

__________________
Jaime E. Maccou