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
