Matthew Knott

SQL Tip: Select Only Rows That DON'T Match In Two Tables

If you're importing data from one table to another, you will probably want to avoid duplicating data. Use this query to select rows from the source table (t1) that DON'T exist in the destination table (t2).