SQLite Forum

Find rows not in other sub query?
Login
Adding to the solutions already mentioned:<code>
  select zip from main
  except
  select zip from zip
</code>. I submit this as a natural way to express "These but not Those".