>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)



>

Thanks that seems to work

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

Yes certainly, in fact I have one at home, but I'm doing this job for a company which uses vfp 5. I have adviced them to upgrade to vfp 9. But I have to say that even vfp 5 is enough for us now.