|
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
