On Sunday 05 November 2006 11:42 am, Alain Roger wrote:
> Hi,
>
> i've tried to run a basic SQL request as followed :
> select *
> from articles, articletypes, department
^ s
> where
> articles.articletype_id = articletype.articletype_id AND
^ no s
> 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.
The table name in the FROM clause has an s on the end. The name in the WHERE
clause does not.
--
Adrian Klaver
[EMAIL PROTECTED]
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
