MS Access SQL Query - syntax error(missing operator) in query expression

Question

I am trying to understand why my query(below) displays an error message in MS Access Sql query editor(sqlview) when I run it.

SELECT *
FROM tblUSPS
INNER JOIN   tblProductUSPS 
ON tblProductUSPS.[PRODUCTUSPS_USPS] = tblUSPS.[USPS_CODE] 
INNER JOIN  tblAttribute 
ON tblUSPS.USPS_ID = tblAttribute.ATTRIBUTE_USPSID

As far as I know the script below if I delete either of the INNER join lines. For instance, this script runs with no errors

SELECT *
FROM tblUSPS
INNER JOIN   tblProductUSPS 
ON tblProductUSPS.[PRODUCTUSPS_USPS] = tblUSPS.[USPS_CODE]

And so does this

SELECT *
FROM tblUSPS  
INNER JOIN  tblAttribute ON tblUSPS.USPS_ID = tblAttribute.ATTRIBUTE_USPSID

But when I combine, something goes wrong and I am unable to find it so I would like some help identifying this please.

Please try googling first, in this case "MS Access multiple inner joins" got me straight to what seems your problem: dbforums.com/microsoft-access/… I mean honestly, SO should not be your first stop for all problems. — Stefan H
– Stefan H, Commented Aug 10, 2012 at 20:03
possible duplicate of Access 2010: Syntax error (missing operator) in query expression — Stefan H
– Stefan H, Commented Aug 10, 2012 at 20:07

Fionnuala · Accepted Answer · 2012-08-10 20:02:32Z

10

Access has strong opinions on parentheses.

SELECT *
  FROM 
(tblUSPS
INNER JOIN   tblProductUSPS 
   ON tblProductUSPS.[PRODUCTUSPS_USPS] = tblUSPS.[USPS_CODE] )
INNER JOIN  tblAttribute 
   ON tblUSPS.USPS_ID = tblAttribute.ATTRIBUTE_USPSID

answered Aug 10, 2012 at 20:02

Fionnuala

91.4k7 gold badges121 silver badges155 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Kobojunkie Over a year ago

Thanks. I was following the tutorial on w3schools and it did not mention that. Thanks

Jesse Over a year ago

If you're learning SQL then I strongly recommend you do not learn it in Access. Oracle, SQL Server have free products and mySQL is completely free.

Fionnuala Over a year ago

For the complete beginner, Access has the query design window that allows you to build joins with drag and drop, in addition there are a number of wizards. You can then switch to sql view to get a good idea of how to build your own queries.

Collectives™ on Stack Overflow

MS Access SQL Query - syntax error(missing operator) in query expression

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related