On 11 Nov 2015, at 8:56am, J.L. Blom <joep at neuroweave.nl> wrote: > I have several tables (3) with exactly the same schema. I have to combine > them to one table but there are overlapping data in each.
Are you doing this just once -- now -- to prepare some data, or do you have to write software which will do this ? You might want to look at this form of the INSERT command: INSERT OR IGNORE INTO bigTable SELECT * FROM sourceTable This form will add rows to a bigTable, but ignore (not insert, generate no error message) any row which would cause any constraint violation, like a duplicate primary key. <https://www.sqlite.org/lang_conflict.html> Simon.