Hi Sergey,

>You want to retrive 2 records, one for EmpPK = 00001 and second for 00002, right?.
Right.

>The question is from which record should fld1 and fld2 come from for each of those keys?
I don't care, any one will do because either:
1. I know that all the values of fld2 are identical for a given fld1 -or-
2. It doesn't matter which value of fld2 I get, any value is ok

Thanks, Chaim