hi all,

i try via this code under not work, any idea

CLOSE all
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
 GO bottom
 brow

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)

thanks.