Hi Everyone,
I am relatively new in SQL / Access Programming. We have a training at the office for simple query like Select * from and found this skill useful for my work...
I have access in my SQL server now, can pull simple data but now, I am trying extract data in two tables:
First table Name: Customer_DB
Columns Available - Customer ID, Name, Address, Age, Total Payment
2nd table: Agent_DB
Columns Available - Agent Name, Agent ID, Customer ID, Agent Total Sales
My question, how do i make this work? Based on the Customer ID in Customer DB, I need to extract the Agents that is handling the customer account. Customer can have multiple agents...
Hope someone can help...
Bookmarks