>Select PrevYear.* > from PrevYear > left outer join mutbdrg > on PrevYear.mijbrpls = mutbdrg.mijbrpls > and PrevYear.vlgnr_mut = mutbdrg.vlgnr_mut > AND mutbdrg.mijbrpls IS NULL >>>
Select prevyear.*, thisyear.vlgnr_mut as recdeleted from prevyear ; left outer join thisyear; on prevyear.mijbrpls = thisyear.mijbrpls and prevyear.vlgnr_mut = thisyear.vlgnr_mutrecdeleted is null for 10 records. But when I do the following :
Select prevyear.*, thisyear.vlgnr_mut as recdeleted from prevyear ; left outer join thisyear; on prevyear.mijbrpls = thisyear.mijbrpls and prevyear.vlgnr_mut = thisyear.vlgnr_mut and thisyear.vlgnr_mut is nullThen all records are set on .null. for the field vlgnr_mut. Is this a bug in vfp5 or am I doing something wrong.....
>>Select mutbdrg.*, b.mijbrpls as recdeleted from mutbdrg; >>left outer join b; >>on b.mijbrpls = mutbdrg.mijbrpls and b.vlgnr_mut = mutbdrg.vlgnr_mut >>>>
previous year
>>>>mijbrpls vlgnrbsvz vlgnrplsvr vlgnr_mut bdr_srt >>21103076903 1 2 29 VSCPRM >>21103076903 1 2 30 AKPKST >>21103076903 1 2 30 APRV >>21103076903 1 2 30 BNSPRV >>21103076903 1 2 30 INCKST >>21103076903 1 2 30 INCPRV >>21103076903 1 2 30 ISOP >>21103076903 1 2 30 PLSOP >>21103076903 1 2 30 1STKST >>21103076903 1 2 31 BHRKST >>21103076903 1 2 32 RISPRM >>21103076903 1 2 33 VSCPRM >>21103076903 1 2 34 AKPKST >>21103076903 1 2 34 APRV >>21103076903 1 2 34 BNSPRV >>21103076903 1 2 34 INCKST >>21103076903 1 2 34 INCPRV >>21103076903 1 2 34 ISOP >>21103076903 1 2 34 PLSOP >>21103076903 1 2 34 1STKST >>21103076903 1 2 35 BHRKST >>21103076903 1 2 36 RISPRM >>21103076903 1 2 37 VSCPRM >>21103076903 1 2 38 AKPKST >>21103076903 1 2 38 APRV >>>>
this year>>
>>mijbrpls vlgnrbsvz vlgnrplsvr vlgnr_mut bdr_srt >>21103076903 1 2 29 VSCPRM >>21103076903 1 2 30 AKPKST >>21103076903 1 2 30 APRV >>21103076903 1 2 30 BNSPRV >>21103076903 1 2 30 INCKST >>21103076903 1 2 30 INCPRV >>21103076903 1 2 30 ISOP >>21103076903 1 2 30 PLSOP >>21103076903 1 2 30 1STKST >>21103076903 1 2 31 BHRKST >>21103076903 1 2 32 RISPRM >>21103076903 1 2 35 BHRKST >>21103076903 1 2 36 RISPRM >>21103076903 1 2 37 VSCPRM >>21103076903 1 2 38 AKPKST >>21103076903 1 2 38 APRV >>21103076903 1 2 38 BNSPRV >>21103076903 1 2 38 INCKST >>21103076903 1 2 38 INCPRV >>21103076903 1 2 38 ISOP >>21103076903 1 2 38 PLSOP >>21103076903 1 2 38 1STKST >>>>As you can see the set of records where vlgn_mut = 34 has been deleted. This set of records I want have.