>insert INTO mstr ;
>    SELECT * FROM main2 WHERE file_date , intervdate NOT IN 
    (SELECT file_date,intervdate FROM mstr)&&try no.1 not work
>
>    SELECT * FROM main2 WHERE file_date and intervdate NOT IN 
    (SELECT file_date and intervdate FROM mstr)&&try no.2 not work

>can i make compare for all fields before insert as

>insert INTO mstr ;
>    SELECT * FROM main2 WHERE all fields NOT IN 
    (SELECT ALL FIELDS FROM mstr)
>

Hi Mohammed,

As you've found out, none of those constructs are valid SQL. It sounds like you're looking for duplicates. First you have to define what constitutes a duplicate and then you can to concatenate all the conditions using STR() for Logical, Numeric and Date values. Be sure not to use Alltrim() or Transform() since they trim extra blanks:

Select * From Table1 Where ;
    chrField + DtoS(dtField) + Str(numField) Not In ;
    (Select chrField + DtoS(dtField) + Str(numField) ;
    From Table2)