vincent
|
Posted: 07/15/2002, 6:18 PM |
|
I am running MySQL 3.22.32, CodeCharge 2.0.5 and with PHP templates.
When I tried to use a MYSQL select command that contain a INNER JOIN and a
ON, I get MySQL error 2000.
e.g. SELECT article_contents.art_content_id, article_contents.art_id,
article_contents.art_content_name, article_contents.art_content,
article_contents.art_content_ord, articles.art_name, articles.art_submit_by
FROM articles INNER JOIN article_contents ON articles.art_id =
article_contents.art_id WHERE article_contents.art_id=22
Anybody else have this same problem?
Thanks,
Vincent
|
|
|
Alexey Alexapolsky
|
Posted: 07/16/2002, 5:01 AM |
|
Did you try to run that command directly in mysql ?
--
Alex,
Support Engineer
CodeCharge Team
"vincent" <vooi@activedrive.com> wrote in message
news:agvs9b$4lv$1@news.codecharge.com...
> I am running MySQL 3.22.32, CodeCharge 2.0.5 and with PHP templates.
>
> When I tried to use a MYSQL select command that contain a INNER JOIN and a
> ON, I get MySQL error 2000.
>
> e.g. SELECT article_contents.art_content_id, article_contents.art_id,
> article_contents.art_content_name, article_contents.art_content,
> article_contents.art_content_ord, articles.art_name,
articles.art_submit_by
> FROM articles INNER JOIN article_contents ON articles.art_id =
> article_contents.art_id WHERE article_contents.art_id=22
>
> Anybody else have this same problem?
>
> Thanks,
>
> Vincent
>
>
>
|
|
|
Anderw I
|
Posted: 07/22/2002, 6:13 AM |
|
I've had this problem. The reason is that MySQL doesn't support INNER JOINS
with a join condition before version 3.23.17 - see http://www.mysql.com/doc/J/O/JOIN.html
Solution is to update MySQL (if you have any influence over the server
administrators), or I suppose re-write the SQL manually so they don't use
the INNER JOIN ... ON syntax.
I'd be interested to hear of any better solutions myself...
Rgds
Andrew
Alexey Alexapolsky <alexa@codecharge.com> wrote in message
news:ah11ut$ake$2@news.codecharge.com...
> Did you try to run that command directly in mysql ?
>
> --
>
> Alex,
> Support Engineer
> CodeCharge Team
>
>
> "vincent" <vooi@activedrive.com> wrote in message
>news:agvs9b$4lv$1@news.codecharge.com...
> > I am running MySQL 3.22.32, CodeCharge 2.0.5 and with PHP templates.
> >
> > When I tried to use a MYSQL select command that contain a INNER JOIN and
a
> > ON, I get MySQL error 2000.
> >
> > e.g. SELECT article_contents.art_content_id, article_contents.art_id,
> > article_contents.art_content_name, article_contents.art_content,
> > article_contents.art_content_ord, articles.art_name,
> articles.art_submit_by
> > FROM articles INNER JOIN article_contents ON articles.art_id =
> > article_contents.art_id WHERE article_contents.art_id=22
> >
> > Anybody else have this same problem?
> >
> > Thanks,
> >
> > Vincent
> >
> >
> >
>
>
|
|
|
|