>>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.
>
Try

Select * from basisverzekering ;
	left outer join wiskunde on basisverzekering.mijbrpls = wiskunde.mijbrpls ;
		AND wiskunde.vlgnr_mut = ( SELECT MIN(vlgnr_mut) FROM wiskunde w2 ;
						WHERE w2.mijbrpls = wiskunde.mijbrpls)

BTW, did you now that VFP9 has been release for quite a while?