joining 2 tables using inner join

[toothpaste]

I have the following 3 tables:

activities:

ID

Guide

Garden

activityDate

comment

activeGuides:

ID

first_name

last_name

gardens:

ID

num

I also have the following working query:

SELECT [first_name] & ' ' & [last_name] AS Guide,
activities.garden,
activities.activityDate,
activities.comment
FROM activities
INNER JOIN activeGuides ON activities.guide = activeGuides.ID

But when I insert another INNER JOIN line which will include the garden's number instead of its ID, things stop working.
Is there a way to enter another INNER JOIN line ?

Thank you

[pbaldy]

Simplest is probably to add the table in design view. If the join doesn't appear automatically, click/drag to create it. Once the query is working, switch to SQL view and check the syntax.

[toothpaste]

Thank you

[pbaldy]

No problemo.