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