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.
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.