HELP! Inner Join Syntax Problem

[jlbucs55]

I am trying to run this inner join, but when I go to launch the report I get a syntax error.

Does anyone see where the error is?

"FROM ((TBL_QUEUES INNER JOIN TBL_TEAM ON TBL_QUEUES.QUEUE_ID = TBL_TEAM.QUEUE_ID)INNER JOIN(TBL_TEAM INNER JOIN TBL_MGRS ON TBL_TEAM.TEAM_ID = TBL_MGRS.TEAM_ID) INNER JOIN TBL_TEAM_OT_DATES ON TBL_TEAM.TEAM_ID = TBL_TEAM_OT_DATES.TEAM_ID " & _

I have tried several different ways of writing, but I keep getting the same syntax message.

Thanks in advance!

 

[MarkSweetland]

At first glance I see that you are missing a closing parenthesis in the overall statement...

If you are trying to access SQL server, it will complain if there is no space between expressions: TBL_TEAM.QUEUE_ID)INNER JOIN(TBL_TEAM

With no specific error message, it's hard to tell...


Mark

 

[Malchik]

Hi
be sure to have the same number of "(" and &quot" in your query. Mal'chik

 

[jlbucs55]

Thanks!

I looked at that report for far too long on a Friday. I took another stab at it, keeping in mind your suggestions, and it works.

I think I will stick to graphics.