query problem (missing operator)

[tombino79]

Hi everyone,

I have a problem with a query.
Just for info, I export some table from SQL to access. The same quary in SQL work fine but when I try in Access come out this error:

------------------------------------------------------------------
Syntax error (missing operator) in query expression 'tbl_Style.FABRICID = tbl_Info.Infoid INNER JOIN tbl_Info AS tbl_Info_1 ON tbl_Info.Parent = tbl_Info_1.Infoid'.
------------------------------------------------------------------

The query:

SELECT tbl_Style.STYLECODE, tbl_Info_1.Infodata AS [Fabric Type]

FROM tbl_Style INNER JOIN

tbl_Info ON tbl_Style.FABRICID = tbl_Info.Infoid INNER JOIN

tbl_Info AS tbl_Info_1 ON tbl_Info.Parent = tbl_Info_1.Infoid


I appreciate your help.

Regards,
Tombino

 

[Michael J Ross]

Try putting ; at the end of your SQL statement

 

[tombino79]

ok I found out now. it was just a missing parenthesis.

Like this work fine:

SELECT tbl_Style.STYLECODE, tbl_Info_1.Infodata AS [Fabric Type]
FROM tbl_Style INNER JOIN (tbl_Info INNER JOIN tbl_Info AS tbl_Info_1 ON tbl_Info.Parent = tbl_Info_1.Infoid) ON tbl_Style.FABRICID = tbl_Info.Infoid

But away In SQL i can write it without.

thanks.

Tom