Thread: basic SQL request
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.
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.
You wrote articletype instead of articletypes in the first WHERE clause: is this the problem? Regards Marco -- Marco Bizzarri http://iliveinpisa.blogspot.com/
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 aklaver@comcast.net
Check this out:
"= articletype.articletype_id AND"
and in your from clause you have something like this:
"from articles, articletypes, department"
So you need to fix "articletypes" or if it is "articletype"
Regards,
-------
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
"= articletype.articletype_id AND"
and in your from clause you have something like this:
"from articles, articletypes, department"
So you need to fix "articletypes" or if it is "articletype"
Regards,
-------
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 11/6/06, Alain Roger < raf.news@gmail.com> wrote:
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.