How to APPEND to a new Table ONLY if it will not make a DUPLICATE???

[taimysho0]

I have a master table that has a column called "last read date" and a column called "days late". the "last read date" column gets updated everyday depending on some criteria. I have another table (lets call it table 2).


i want it so that rows from the master table will append to table 2 ONLY if the "days late" is more than 4 AND that it will not append if it will make an exact duplicate copy in table 2. thanks

[taimysho0]

ive looked at some similar threads and it looks like they are using the "Not In" critera. How would i use this for my query?? ex:

Not In( Select Channel ID & Date Requested from Table) for example?