>hi,
>thank you for reply,
>NUM field is numeric type(5,0),
>how i can get SP1 for VFP9 ,
>
> ok ,i try as under, still the same.
>

>insert INTO mstr ;
> Select * From main2 Where ;
>  DtoS(file_date) + DtoS(intervdate)+Str(num, 5) Not In ;
>   (Select  DtoS(file_date) + DtoS(intervdate)+Str(num, 5) ;
>    From mstr)
>
>

>thanks.
>

The link to download Service Pack 1 for Visual FoxPro 9 is:

http://www.microsoft.com/downloads/details.aspx?FamilyId=1C06E35D-10A2-4A05-84FC-495B3A73ECF7&displaylang=en

And you have indexes in both tables on the exact expression?

Instead of using one insert command do it into 2 steps (here I think it may help). First select records into cursor

Select * From main2 Where ;
  DtoS(file_date) + DtoS(intervdate)+Str(num, 5) Not In ;
   (Select  DtoS(file_date) + DtoS(intervdate)+Str(num, 5) ;
    From mstr) into cursor curInsert nofilter

insert into Mstr select * from curInsert