CODEWITHSUNDEEP
sqlms-accessinner-join
LucashS
LucashS

Reputation: 23

Two INNER JOIN ODBC MSAccess exception with query

I have a problem.. I want to connect to my database with odbc to msAccess from c# app. I have got exception error. Please my query... It should work but apparently I am doing something in wrong way here..

ERROR [42000] [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression '[autoResults].[autoStats]=[autoStats].ID INNER JOIN [users] ON [users].ID=[autoStats].userID


string queryString =@"
SELECT [erNumber].[autoResults],
[passedTesting].[autoResults],
[releaseVersion].[autoStats],
[lastFunction].[autoResults],
[startTime].[autoStats],
[Name].[users]
FROM [autoStats] 
INNER JOIN [autoResults] 
 ON [autoResults].[autoStats]=[autoStats].ID
INNER JOIN [users]
 ON [users].ID=[autoStats].userID
WHERE [erNumber].[autoResults] LIKE '" + TextBox1.Text + "'";

Upvotes: 2

Views: 1542

Answers (1)

Gord Thompson
Gord Thompson

Reputation: 123829

Access can be fussy about multiple JOINs and often requires that they be enclosed in parentheses. So instead of

FROM [autoStats] 
INNER JOIN [autoResults] 
 ON [autoResults].[autoStats]=[autoStats].ID
INNER JOIN [users]
 ON [users].ID=[autoStats].userID

try

FROM 
    (
        [autoStats] 
        INNER JOIN 
        [autoResults] 
            ON [autoResults].[autoStats]=[autoStats].ID
    )
    INNER JOIN 
    [users]
        ON [users].ID=[autoStats].userID

Upvotes: 3

Related Questions