Thanks for ur time GregVB,
Sally shows up twice cos she's had 2 positions with the company (2 records in the empPositions table). She is no longer with the company, so the 2 positions she held have been archived (i.e. field Archiveflag=1).
I'd like to select the one with the most recent...