I have no clue on what/where to look for my requirement, however, I have done some reading about INNER JOIN and it looks like that is something I need to use, but, I am not sure how.

Here is my current table structure (I have omitted some fields from this example and have given some sample data in italics to make the table structure more clear.


ID (autonumber) 3
EmployeeName John
EmployeePhone 555999555
EmployeeLocation New York


ClientID (autonumber) 1 , 2 , 3
ClientName ABC Company , XYZ Company, PQR Company

LocationID 1 , 2
Location New York , Chicago

tblEmployeeClients (junction table)
fkeyID 3
EmployeeClients (multivalued number) 1,2

The junction table tblEmployeeClients only stores ID of the Employee and in the second column (which is a multi-valued field), the ID of each of the clients the employee Supports.

I am trying to generate a report that lists say, EmployeeName alongside the clients supported by the Employee (listing the client location is not required, however, it would be good to know how to do that as well).

The report (for the example above), should look like this:

Name Clients Supported
John ABC Company, PQR Company

Currently, I am able to get :

John 1, 2 i.e the client ID for the clients that the employee supports instead of the corresponding company names.

Hope, someone here can help me with this requirement.