Oledb Syntax error ("missing operator") in query expression

49 Views Asked by At

I'm using ole db as follows:

_adapter = new OleDbDataAdapter(command);
_adapter.Fill(Set);

command.commandtext is populated with:

"SELECT [Roster$].[ID],[Roster$].[Name],[Roster$].[Level],[Events$].[Name],[Scores$].[Score] 
FROM [Roster$] 
Inner Join [Scores$] on [Scores$].[CompetitorId] = [Roster$].[ID] 
Inner Join [Events$] on [Events$].[ID] = [Scores$].[EventId] 
where [Roster$].[ID] = 1"

The error I'm getting is:

Syntax error (missing operator) in query expression '[Scores$].[CompetitorId] = [Roster$].[ID] Inner Join [Events$] on [Events$].[ID] = [Scores$].[EventId]'.

Not sure where I'm going wrong.

Edit: I'm trying to connect to an Excel Database BTW

0

There are 0 best solutions below