Question
Syntax error (missing operator) in query expression works in sql
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'.
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'.
