Other database engines provide methods of doing this, but I don't think sqlite does. I would use an insert statement that uses select to copy the content of one table into the other.
insert into X(field1,field2) select field1,field2 from Y --- Richard Boyd <[EMAIL PROTECTED]> 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 > ===== --------------------------------- "Lord Tarlington gazed upon the crazed Egyptian hieroglyphics on the walls of the ancient tomb of the petrified pharaoh, he vowed there would be no curse on him like on that other Lord, unless you count his marriage to Lady Tarlington who, when the lost treasure was found, will be dumped faster than that basket in the bulrushes." Melissa Rhodes --------------------------------- The Castles of Dereth Calendar: a tour of the art and architecture of Asheron's Call http://www.lulu.com/content/77264 __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
