Re: query

Article View: cn.comp.database.mysql

Article #79

Back to cn.comp.database.mysql Previous Next

#79

From: William Morris
Date: Wed, 09 Jun 2004 15:27

14 lines
1219 bytes

I wonder if "RECORD" isn't a reserved word...

"Sergei Shelukhin" <raven_at@home.domonet.ru> wrote in message
news:2iab39Fkoct2U1@uni-berlin.de...
> I have mysql 3.22.27, and i am executing the following query:
>
> SELECT * FROM Category INNER JOIN Record ON Category.CategoryId =
> Record.CategoryId ORDER BY Category.Name ASC
>
> I get an error near ON ...; what's wrong with it? Both tables and columns
do
> exist.
>
>

Technical Details

Message-ID: <2iooj4Fpdk5lU1@uni-berlin.de>

Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!fu-berlin.de!uni-berlin.de!not-for-mail

References: <2iab39Fkoct2U1@uni-berlin.de>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 114450,17ab37ef85df3346,start
X-Google-Attributes: gid114450,public
Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!fu-berlin.de!uni-berlin.de!not-for-mail
From: "William Morris" <news.remove.this.and.the.dots@seamlyne.com>
Newsgroups: cn.comp.database.mysql
Subject: Re: query
Date: Wed, 9 Jun 2004 10:27:27 -0500
Lines: 16
Message-ID: <2iooj4Fpdk5lU1@uni-berlin.de>
References: <2iab39Fkoct2U1@uni-berlin.de>
Reply-To: "William Morris" <news.remove.this.and.the.dots@seamlyne.com>
X-Trace: news.uni-berlin.de RvtF3vXrTAIVHUeWTSDBfAEVR6gPWYk7y+CexP96A5mL892UUA
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1409
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409

Reply to Parent Message