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
