How to pull data from two tables

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