Joining Queries

[Mike]

I have two tables:
- One table is the result of quering out some criteria and it now
has fields: Division, Store, Transaction #, line (which shows whether it is a
total, deposit, tax, tendered) - it is queried out by total, and
concatenation field which has division-store-transaction#.

- My second table has all data and the same fields including the
concatenation, and has all of the line fields including total, deposit, tax,
and tendered.

I want to be able to join these two tables together in order to bring back
all of the line names that correspond with the first table.

Thanks in advance.
Mike

 

[golfinray]

You need to join the tables with a key. It looks like transaction# might make
a good key to join on. You may have to add that field to the first table. Now
you would have something in common between the tables that would allow you to
have a one-to-one or one-to-many relationship.