SQLite Forum

Hide rows in table1 if same value found in table2 ?
If you can change the schema, add a column to store the "deleted" attribute, so you can SELECT ... WHERE NOT deleted.


SELECT ... WHERE NOT EXISTS (SELECT 1 FROM table2 where table2.field == table1.field);


SELECT ... WHERE table1.field NOT IN (SELECT DISTINCT field FROM table2);

Edit: added DISTINCT to above SELECT