Either a join with suitable criteria, or [the compound operator](https://sqlite.org/syntax/compound-operator.html), "EXCEPT", will do that trick.
Either a join with suitable criteria, or [the compound operator](https://sqlite.org/syntax/compound-operator.html), "EXCEPT", will do that trick.