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

Question

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

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 one of the lines of the INNER connection. For example, this script works without errors

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

And it does

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

But when I combine, something goes wrong, and I can’t find it, so I would like some help in this to be indicated.

Answer 1

Access has strong opinions about parentheses.

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