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...
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...