>How do you define the first match for wiskunde in terms of data? What VFP version are you using?
>

The Wiskunde records for one "mijbrpls" is ordered by a sequence number (vlgnr_mut) ascending:

mijbrpls vlgnr_mut 
10000    1
10000    2
10000    3
10000    4
10001    1
10001    2

So I want the matches: "10000,1" and "10001,1"

I am sorry for leaving out the vfp version, I am using VFP 5.

>>
>>I am using a left outer join between two tables basisverzekering and wiskunde:
>>
>>

>>
>>Select basisverzekering.* from basisverzekering;
>>left outer join wiskunde on basisverzekering.mijbrpls = wiskunde.mijbrpls
>>
>>

>>
>>Basisverzekering is unique on mijbrpls, but in wiskunde it is not. If I just want one record (the first match) from wiskunde instead of all the matches, how do I achieve this within one query