Many thanks for the replies. I knew it must be something simple!!
Cheers, R. -----Original Message----- From: John LeSueur [mailto:[EMAIL PROTECTED] Sent: 31 January 2005 21:27 To: sqlite-users@sqlite.org Subject: Re: [sqlite] joining a table to the end of another table Richard Boyd wrote: > Hi, > > I’m inexperienced with databases so forgive me if this is a silly > question. > > What I want to do is join to separate tables together into one table. > This is to enable me to synchronize databases held on remote systems. > I would use a master table which would have the dates of each update > and then I could see which databases need updated so that they all the > same. > > Every time I add data to the main database I put it in a new table, > with exactly the same structure as its predecessors. Then updating is > a simple matter of checking to see which tables I have on the remote > machine and then copying across the tables which are not there. My > problem is I’m unclear how to link multiple tables sequentially. I’ve > looked into joins but they seem to be a way of performing relational > searches which is not what I’m after. > > See example below if it’s not clear what I’m looking to do: > > Table 0 Table1 > > 0 | A 5 | F > > 1 | B 6 | G > > 2 | C 7 | H > > 3 | D > > 4 | E > > Combined table > > 0 | A > > 1 | B > > 2 | C > > 3 | D > > 4 | E > > 5 | F > > 6 | G > > 7 | H > > I’m sure there’s a simple way to do it but I’m not sure how. > > Thanks in advance… > > Richard > >------------------------------------------------------------------------ > >No virus found in this outgoing message. >Checked by AVG Anti-Virus. >Version: 7.0.300 / Virus Database: 265.8.1 - Release Date: 27/01/2005 > > insert into combined_table select * from table0 union select * from table1 John -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 265.8.1 - Release Date: 27/01/2005 -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 265.8.1 - Release Date: 27/01/2005
