Merge 2 tables question

  • Thread starter Thread starter Bob Leffew
  • Start date Start date
B

Bob Leffew

I use Access 2000 along with Visual Basic 6.0.

I have a database with two tables that are identical in setup. The first
table is main contacts and the second table is secondary contacts. They are
identical in field names. The relationship between records in the tables is
the customer number.

For example there would be only one Customer # 1 in the main contact but
could be multiple secondary contacts in the second table with customer # 1;
obviously all being from the same company.

I realize I probably should have combined the database into one database
from the beginning, coding the difference in the contacts but I didnt.

What I need to do is somehow create a query or temporay database combining
the two databases for data purposes. One side note; again the file
structure is the same for both with a field called ContactCode which for the
main contacts is 0 and in the secondary contact database this code is 1. (I
did this way after creating the database initially)

Any suggestions?

Bob Leffew
 
Use UNION query:

SELECT * FROM tblMainContacts
UNION
SELECT * FROM tblSecondaryContacts

You'll have to type this in the SQL window, can not use
the query builder grid.

:-)
 
Thank you,

Great help, I appreciate it.

Bob

Dejan said:
Use UNION query:

SELECT * FROM tblMainContacts
UNION
SELECT * FROM tblSecondaryContacts

You'll have to type this in the SQL window, can not use
the query builder grid.

:-)
Click to expand...
 
Back
Top