basic SQL request - Mailing list pgsql-general

From Alain Roger
Subject basic SQL request
Date
Msg-id 75645bbb0611051142u5ce1f38aw730cad439ac00bbd@mail.gmail.com
Whole thread Raw
Responses Re: basic SQL request
Re: basic SQL request
Re: basic SQL request
List pgsql-general
Hi,

i've tried to run a basic SQL request as followed :
select *
from articles, articletypes, department
where
    articles.articletype_id = articletype.articletype_id AND
    articles.department_id = department.department_id AND
    articles.validity_period_end > now()

and i got the following error message :
ERROR:  missing FROM-clause entry for table "articletype"

i'm confused now, if i use LEFTJOIN it's the same, so where is the trouble ?

thx,

AL.

pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: Simple stored procedure examples?
Next
From: "Marco Bizzarri"
Date:
Subject: Re: basic SQL request