>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