Comparing Tables For A Querie

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

Guest

I have database which has alot of tables, not all are important for the
querie though. There are only 3 imporant ones. Table A contains 3 critical
fields ... the ID f a customer, the ID of the location where he made the
purchase, and the date of the purchase. Table B contains the customers info
.... First Name, Last Name, and the ID.able C contains the name of the Store
in which the customer made the purchase, and the ID of the location.

I need to make a querie which displays the ammount of purchase made by each
of the customer in Table A, and also where they made the purchase. The thing
is they are ALOT and it has to be based on their Names and NOT their IDs
which is what its used on the Table A to identify them.

Any help would be greatly appreciated ... Thanks.
 
Dear Pro:

Shall we assume that the Location in TableA references the Store in
TableC? That is, is a Location the same thing as a Store? (BTW,
using consistent terminology in discussing your challenge is important
to accurately conveying the information).

What is the difficulty in simply using INNER JOINs between the tables?
Or is that perhaps the point you do not understand? That is the way
you can relate rows between the 3 tables so the query will return
things like the FirstName and LastName along with the LocationName.

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts
 
Back
Top