SQL join operators in select query

[Christian Sol]

I am confuse about combining and view recordes in 3 different tables simultaneously using the SQL join Operatores in the select query statement;Sales Person,Customer s and Orders.
sample statement(Show the age of SalesPeople who have an Order Customer in the city Memphis which the city is in the Customer table and the Age is in the SalesPerson Table and the order is in Orders Table.

[Rixxe]

The best way to understand this might be to use the UI in access, as it gives you the joins.

From trying to understand what you have described:
Do you have an ID thats unique for each customer in each table?
If so, you can link each table through the ID, then run whatever query you need.

To understand how joins work, use google and search 'SQL joins'... i'm sure you will find something.