Syntax error (missing operator) in query expression works in sql

[Guest]

Hi guys,

I am having a problem with this query in Access 2007, it runs fine in MSSQL.

I get this error when I run it.

[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'tbl_skuoption_rel.optn_rel_Option_ID = tbl_skuoptions.option_ID INNER JOIN tbl_skus ON tbl_skuoption_rel.optn_rel_SKU_ID = tbl_skus.SKU_ID INNER JOIN tbl_products AS p ON tbl_skus.SKU_ProductID = p.product_ID'.

[cf_dev2]

Access may require parenthesis ( ) around the JOINs when joining more than two tables

[paross1]

The old pre-ANSI 92 syntax should work too ("joining" in the WHERE clause)

Phil