CODEWITHSUNDEEP
sqlms-access
user2687634
user2687634

Reputation:

Having trouble combining INNER JOINS

I am having some trouble combining some inner joins in the following piece of code:

SELECT Table1FakeName.Field1
FROM Table1 AS Table1FakeName
INNER JOIN Table2 AS Table2FakeName ON Table1FakeName.Field2 = Table2FakeName.Field2
INNER JOIN Table3 AS Table3FakeName ON Table2FakeName.Field2 = Table3FakeName.Field2;

I am getting the following error:

Syntax Error (missing operator) in query expression 'Table2FakeName.Field2 INNER JOIN Table3 AS Table3FakeName ON Table2FakeName.Field2 = Table3FakeName.Field2'

PS: Please do not vote down on this post. If you have a reason for doing so, discuss it in the comments section.

Upvotes: 0

Views: 59

Answers (1)

Guneli
Guneli

Reputation: 1721

Try this:

SELECT Table1FakeName.Field1
FROM ((Table1 AS Table1FakeName
INNER JOIN Table2 AS Table2FakeName 
      ON Table1FakeName.Field2 = Table2FakeName.Field2)
INNER JOIN Table3 AS Table3FakeName
      ON Table2FakeName.Field2 = Table3FakeName.Field2);

In Access you need an additional bracket before the FROM clause for every extra table you join, and one closing bracket for the JOIN's ON clause.

Upvotes: 1

Related Questions