Joining two tables

[Jamie Harbour via AccessMonster.com]

I have to tables of information, one contains inofrmation on staff members
from 1 company, the other hold the same information about another company,
does anybody know how i would be able to create a query that displayed both
sets of data within one query. the field names within both tables are
identical.

Thanks

Jamie

 

[Rick B]

If the field names are identical, I would probably fix my data structure.
Make this into one table and add a field called "Company" with a drop-down
to select which company the members belong to. To make it easy, add this
field to both tables, run two separate update queries to change the field in
each table to the appropriate entry, run an append query to move all the
records from one table to the other, then delete the extra table.

This would create a more normalized design from which to work.

 

[Rick B]

If, for some reason you don't want to do that, then create a UNION query to
pull all the records from both tables. Use the built-in help files if you
need help building a UNION query.

 

[Jamie Harbour via AccessMonster.com]

I realise that what i want to do is not the most sound structurally but
unfourtunately its the only way i can do it, Sorry Risck, are there any other
offers on what to do?

 

[Jamie Harbour via AccessMonster.com]

Thanks a lot Rick