What I would like to do is create an sql statement that grabs data from multiple tables, that are related by different id fields.
This is what I have tried:

"SELECT * FROM [SCHEDULE] INNER JOIN [CLIENTS] ON " & _
"[SCHEDULE].[CLIREF] = [CLIENTS].[CLIREF] AND " & _
"INNER JOIN [EMPLOYEES] ON [SCHEDULE].[EMPREF] = " & _
"[EMPLOYEES].[EMPREF]"

What I have is a schedule table that links both clients and
employees together based upon their reference fields. I need to be able to select information from the client,employee and schedule table. I think I just have the sql syntax wrong, but I can't figure it out.

Any suggestions????