>>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.
Do you mean my code doesn't work? What's the error message?
Edward Pikman
Independent Consultant