I have two tables, called table1 and table2. Both have date and id as columns, and table2 is a small subset of table1 entries. How do I remove all entries that exist in table2 from table1 by matching up date and id?
select from table1 where not([]date;id)in table2