>insert INTO mstr ; > Select * From main2 Where ; > file_date Not In ; > (Select file_date From mstr) >>
>>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.