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