Skip to main content
October 31, 2007
Question

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

  • October 31, 2007
  • 1 reply
  • 642 views
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'.

This topic has been closed for replies.

1 reply

Inspiring
October 31, 2007
Access may require parenthesis ( ) around the JOINs when joining more than two tables

Participating Frequently
October 31, 2007
The old pre-ANSI 92 syntax should work too ("joining" in the WHERE clause)

Phil