Union Joins

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Ok, here's the deal. I have created a database for one of my clients and for
security reasons I need to use two tables to hold the exact same type of
information. One table is for general use, the other table is only used by
the administrator. But because the information is all the same, I need a way
to join the two tables together thru a query so that the dropdown box
displays all the combined information from the two tables. The reason I
don't just create one table, is because my clients are on a peer-to-peer
network. Any changes to the base table will be seen by all users. I need
the main table in the back-end for everyones use, but the extra table in the
front-end of just the administrator for their use.

As far as I can tell, in MS Access there is no way to join two tables in a
query without physically moving the data from one table into the other table
in an Append Query. I don't want to physically move the information, I only
want to join them temporarily in a query only long enough for the
administrator to make their selection.

Is this possible in MS Access? If not, why not?????
 
If both tables have the same basic stucture, a UNION ALL query should work
just fine.

SELECT Asa.* FROM Table1
UNION ALL
SELECT Asa.* FROM Table2;
 
Jerry, today you can go home and say to yourself...I helped someone. Thank
you!

Actually, you have a pretty cool job and can probably say that every day! ;)
 
Doing this isn't my job. In fact my boss would chew me out if he knew I was
answering database questions for free!
 
Well then, it will be our little secret. Thanks again, you saved me many
hours of aggravation.

Christiane
 
Back
Top