'where' clause error in postgreSQL

Question

I'm new to postgreSQL. I'm trying to execute some simple queries but i'm having an error i'm stuck with. Following is a simple query

select e.street, e.city 
from employee e join works w join managers m on e.Lastname=w.Lastname 
and w.Lastname=m.MLastname
where w.companyname='Union Pacific';

The error that is being thrown while executing this query is

ERROR:  syntax error at or near "where"
LINE 4: where w.companyname='Union Pacific';
        ^

********** Error **********

ERROR: syntax error at or near "where"
SQL state: 42601
Character: 124

I couldn't understand this error. Need some help.

aib · Accepted Answer · 2012-11-14 20:29:09Z

3

Did you mean

select e.street, e.city 
from employee e
join works w
join managers m on (e.Lastname=w.Lastname and w.Lastname=m.MLastname)
where w.companyname='Union Pacific';

? Probably not. Probably you meant:

select e.street, e.city 
from works w
join employee e on w.Lastname=e.Lastname
join managers m on w.Lastname=m.MLastname
where w.companyname='Union Pacific';

edited Nov 14, 2012 at 20:29

answered Nov 14, 2012 at 20:23

aib

47.4k10 gold badges75 silver badges79 bronze badges

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

Comments

Augustus Kling · Accepted Answer · 2012-11-14 20:25:56Z

1

The join of works lacks a join condition. Follow it with on or using.

answered Nov 14, 2012 at 20:25

Augustus Kling

3,3331 gold badge24 silver badges25 bronze badges

Collectives™ on Stack Overflow

'where' clause error in postgreSQL

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related