[sqlite] combining overlapping tables

2015-11-11 Thread Keith Medcalf
ounces at mailinglists.sqlite.org [mailto:sqlite-users- > bounces at mailinglists.sqlite.org] On Behalf Of Igor Tandetnik > Sent: Wednesday, 11 November, 2015 07:32 > To: sqlite-users at mailinglists.sqlite.org > Subject: Re: [sqlite] combining overlapping tables > > On 11/11/2015 3:56 AM, J.L

[sqlite] combining overlapping tables

2015-11-11 Thread J.L. Blom
Hi , I am rather unknown to sqlite and I have the following problem. 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. So e.g. table one ends (in column one) on 2015-07-21 11:55 and the next starts on

[sqlite] combining overlapping tables

2015-11-11 Thread Simon Slavin
On 11 Nov 2015, at 8:56am, J.L. Blom 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

[sqlite] combining overlapping tables

2015-11-11 Thread Igor Tandetnik
On 11/11/2015 3:56 AM, J.L. Blom wrote: > So e.g. table one ends (in column one) on 2015-07-21 11:55 > and the next starts on 2015-07-19 > 17:50 > There is an overlap op 2 days approx. 380 rows (each row contains 53 > items). > Is there a script - or commando