Search code examples
kdb

remove overlapping entries from a table KDB+/Q


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?


Solution

  • select from table1 where not([]date;id)in table2