>The check for NULL has to be in the WHERE clause
>

>Select PrevYear.* ;
>	from PrevYear ;
>	left outer join thisyear ;
>		on PrevYear.mijbrpls = thisyear.mijbrpls ;
>			and PrevYear.vlgnr_mut = thisyear.vlgnr_mut ;
>	WHERE thisyear.vlgnr_mut IS NULL
>

This seems to be a bug in VFP 5, this works fine on my homecomputer with vfp 9 but at work it fails. Too bad for me . Could this be achieved w/o a left outer join (because left outer join has been introduced in VFP 5). Thanks beforehand. I have tried Edward's suggestion, but this is not workable.