SQLite: delete all records from table specified in another table

sqlite sql-delete

Try this query

Delete from mytab where id in (select id from deltab);

sqlite sql-delete

Try this:

DELETE FROM mytab       WHERE EXISTS (SELECT *              FROM deltab              WHERE deltab.ID = mytab.ID)

CodeHunter