Bringing together 2 databases

[Guest]

I have 2 databases which I am bringing together. I have imported one
database into the other.

What is the best way to think about combining data from both in a query?

Each has fairly similar fields in their respective tables.

 

[Joseph Meehan]

I have 2 databases which I am bringing together. I have imported one
database into the other.

What is the best way to think about combining data from both in a
query?

Each has fairly similar fields in their respective tables.

Update query.

 

[Guest]

I have 2 databases which I am bringing together. I have imported one
database into the other.

What is the best way to think about combining data from both in a query?

It depends on how you want to "combine" them. Joseph's suggestion of an
UPDATE query is correct if you want to create new records by combining
existing records from the two tables (linked by some unique field);
alternatively, an APPEND query will let you add records from one table as new
records in another. A UNION query will let you display the records from both
tables as if they were from one "taller" table, without affecting either
table permanently.

 

[Guest]

Hi John, Can you help me with something similar. I want to make a 'tall'
table from multiple sets of fields contained within the same table, the
sample below works fine...

SELECT [Run_Point_Venue_A], [Run_Point_Address_A]
FROM Run_Points

UNION SELECT [Run_Point_Venue_C], [Run_Point_Address_C]
FROM Run_Points;

....but when i want to add additional Select fields, such as the following:

UNION SELECT [Run_Point_Venue_D], [Run_Point_Address_D]
FROM Run_Points;
UNION SELECT [Run_Point_Venue_E], [Run_Point_Address_F]
FROM Run_Points;
UNION SELECT [Run_Point_Venue_G], [Run_Point_Address_G]
FROM Run_Points;

etc, etc.

the query fails with various messages depending on what syntax i experiment
with.

i have looked in the manual and online for help on using more than two
'instances' of select, but can't find the asnwer.