Inner Join with three tables... what am I doing wrong?

[Noozer]

Can anyone see what is wrong with the following query?

SELECT * FROM Tickets
INNER JOIN Choices2Ticket ON Tickets.TicketKey=Choices2Ticket.TicketKeyLink
INNER JOIN Choices ON Choices2Ticket.ChoiceKeyLink=Choices.ChoiceKey;

When I try and save this query I get the following error:

Syntax error (missing operator) in query expression
'Tickets.TicketKey=Choices2Ticket.TicketKeyLink INNER JOIN Choices ON
Choices.ChoiceKey=Choices2Ticket.ChoiceKeyLink'.

All the table and column names are spelled correctly and do exist in the
specified tables.

This is running on MS Access 2003... eventually to be used on an ASP page
with the JET engine.

 

[giorgio rancati]

Hi, Noozer

they are lacking the parenthesis in the first join.

 

[Noozer]

Thanks! I new I was doing something dumb...

Hi, Noozer

they are lacking the parenthesis in the first join.
----
SELECT * FROM (Tickets
INNER JOIN Choices2Ticket ON
Tickets.TicketKey=Choices2Ticket.TicketKeyLink)
INNER JOIN Choices ON Choices2Ticket.ChoiceKeyLink=Choices.ChoiceKey;