hi,
thank you verey much for every thing, it's ok now.

thanks again.



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