Syntax error in FROM Clause

Question

hi all I'm working on asp.net web application & for this use MS access for back end, My Query is given below which is successfully executed on MS Access but error on front end ("Syntax Error in FROM Clause")

select USER.EMPID as EMPID,USER.FULLNAME as FULLNAME,
USER.USERNAME as USERNAME,Employee.ROLEID,ROLE.ROLENAME AS ROLE 
FROM USER 
inner join employee on user.userid=employee.userid 
inner join role on employee.roleid=role.roleid  
WHERE  USER.EMAIL='[email protected]' 
AND USER.PASSWORD='cZdqAEeDV2EVzA1JNFJ6hQ==' 
AND USER.STATUS='Enable'

Any help is greatly appreciated.

Patrick Honorez · Accepted Answer · 2010-10-18 12:22:04Z

1

As a general rule, I would advise that you build your query using MS Access.
Build it in Design view, test in in Dataheet view, then switch to SQL view and copy paste SQL stqtement to you app.
This way you will avoid a lot of errors.

answered Oct 18, 2010 at 12:22

Patrick Honorez

25.4k12 gold badges97 silver badges163 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

David-W-Fenton Over a year ago

...in particular it will avoid Jet/ACE's pickiness about parentheses on the JOINs in the FROM clause.

Fionnuala · Accepted Answer · 2010-10-18 12:41:05Z

1

I am very surprised the query works for you. Access is fussy about parentheses and you are missing some:

Select USER.EMPID as EMPID,USER.FULLNAME as FULLNAME,
USER.USERNAME as USERNAME,Employee.ROLEID,ROLE.ROLENAME AS ROLE 
FROM (USER 
inner join employee on user.userid=employee.userid )
inner join role on employee.roleid=role.roleid  
WHERE  USER.EMAIL='[email protected]' 
AND USER.PASSWORD='cZdqAEeDV2EVzA1JNFJ6hQ==' 
AND USER.STATUS='Enable'

answered Oct 18, 2010 at 12:41

Fionnuala

91.4k7 gold badges121 silver badges155 bronze badges

2 Comments

Fionnuala Over a year ago

Would the person who down voted care to explain how they succeeded in running an ms-access query that leads to missing operator error in both plain Access and ANSI 92 mode, please? Regarding the use of the keyword user, square brackets around it will correct the problem, though renaming is preferable.

Fionnuala Over a year ago

@David-W-Fenton Thanks, David. It should be helpful to readers who wonder why they cannot get away with missing brackets :D

amol · Accepted Answer · 2010-10-18 13:52:13Z

0

I changed the name of my user table to users & update query regarding this change & problem resolve successfully.

answered Oct 18, 2010 at 13:52

amol

114 bronze badges

Collectives™ on Stack Overflow

Syntax error in FROM Clause

3 Answers 3

1 Comment

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related