>Hi Zakaria
>First, i wouldnt call the second table b. Give it another name since Foxpro may think you want to select the 2nd work area.
>Also, assuming bdr_srt is the primary key, why don't you just run:
>
>select * from mutbdrg where mutbdrg.bdr_srt not in ;
> ( select bdr_srt from bTable )
>
>
>Jaime
>
Hi Jaime,
I didn't say it in my initial message but I was just testing in the command window, having both tables open with the same name so that is why the b thing...
Unfortunately I can't do your suggestion because bdr_srt is not a primary keys. Thanks.
>>Hi all,
>>
>>I'm having a big problem with a query which doesn't work (the query doesn't finish and computer goes on tilt). I have two tables who are almost identical only that one table is of the previous year and the other of this year. Every year the number of records get bigger but it also happens that there are records that have been deleted in the new download. I want to know the deleted records from the old table by comparing both tables with a query. Both that tables are more than 7 million records (I say this because I think that foxpro can't handle this, is this true?). The query is very simple:
>>
>>
>>Select mutbdrg.*, b.mijbrpls as recdeleted from mutbdrg;
>>left outer join b;
>>on b.mijbrpls = mutbdrg.mijbrpls and b.vlgnr_mut = mutbdrg.vlgnr_mut
>>
>>
>>
>>Mutbdrg is of this year and b of previous year. So the goal is to have the deleted records. But this query doesn't get finished....
>>
>>I'm having the following datasample:
>>
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.
>>
>>How could i do this?
>>
>>Thanks beforehand
