[GENERAL] basic SQL request

2006-11-05 Thread Alain Roger 
Hi,i've tried to run a basic SQL request as followed :select *from articles, articletypes, departmentwhere 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 articletypei'm confused now, if i use LEFTJOIN it's the same, so where is the trouble ?
thx,AL.

Re: [GENERAL] basic SQL request

2006-11-05 Thread Marco Bizzarri 

You wrote articletype instead of articletypes in the first WHERE
clause: is this the problem?

Regards
Marco


--
Marco Bizzarri
http://iliveinpisa.blogspot.com/

---(end of broadcast)---
TIP 4: Have you searched our list archives?

  http://archives.postgresql.org/

Re: [GENERAL] basic SQL request

2006-11-05 Thread Adrian Klaver 
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

Re: [GENERAL] basic SQL request

2006-11-05 Thread Shoaib Mir 
Check this out:= articletype.articletype_id ANDand in your from clause you have something like this:from articles, articletypes, departmentSo you need to fix articletypes or if it is articletype
Regards,---Shoaib MirEnterpriseDB (www.enterprisedb.com)On 11/6/06, Alain Roger 
[EMAIL PROTECTED] wrote:Hi,i've tried to run a basic SQL request as followed :
select *from articles, articletypes, departmentwhere 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 articletypei'm confused now, if i use LEFTJOIN it's the same, so where is the trouble ?
thx,AL.