USE main2 select main2 INDEX on file_date TO ll USE mstr select mstr INDEX on file_date TO tt insert INTO mstr ; Select * From main2 Where ; DtoS(file_date) + DtoS(intervdate)+Str(num) Not In ; (Select DtoS(file_date) + DtoS(intervdate)+Str(num) ; From mstr)thanks.
>>USE main2 >>select main2 >>INDEX on DtoS(file_date) + DtoS(intervdate)+Str(num) TO ll >> >>USE mstr >>select mstr >>INDEX on DtoS(file_date) + DtoS(intervdate)+Str(num) TO tt >>insert INTO mstr ; >> Select * From main2 Where ; >> DtoS(file_date) + DtoS(intervdate)+Str(num) Not In ; >> (Select DtoS(file_date) + DtoS(intervdate)+Str(num) ; >> From mstr) >>>>thanks.