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 MirEnterpriseDB (www.enterprisedb.com)On 11/6/06, Alain Roger <
[EMAIL PRO
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
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?
htt
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 messa
