* Rory McKinley <[EMAIL PROTECTED]> [20040109 13:21]: wrote:
> On 7 Jan 2004 at 11:04, Odhiambo Washington wrote:
>
> >
> > Hello,
> >
> > I have a query that executes well when run on MySQL-4.x, but not 3.23.x:
> >
> > SELECT popbox.local_part, popbox.password_hash, popbox.domain_name,
> CONCAT(domain.path,'/',popbox.mbox_name) AS path FROM popbox JOIN domain
> USING (domain_name)
> >
> > I would like to make this query run on a 3.23.58 server. I have tried
> >
> > SELECT popbox.local_part, popbox.password_hash, popbox.domain_name,
> CONCAT(domain.path,'/',popbox.mbox_name) AS path FROM popbox JOIN domain
> ON popbox.domain_name=domain.domain_name
> >
> > ..but I still end up with error. Of course I am lost about the syntax
> > now ;) Basically, the problem begings with the USING...
[snip]
>
> Hi Wash
>
> Can you post the error message?
>
The line is part of a small script. The error is:
"You have an error in your SQL syntax near 'USING (domain_name)'"
Best regards,
Odhiambo Washington
Wananchi Online Ltd.
PS::REQUEST
A: Because it reverses the logical flow of conversation.
Q: Why is top posting frowned upon?
http://learn.to/edit_messages
http://www.netmeister.org/news/learn2quote.html
----------------------------------+-----------------------------------------
Odhiambo W. wash(at)wananchi(dot)com . WANANCHI ONLINE LTD (Nairobi, KE)
http://www.wananchi.com/email/ . 1ere Etage, Loita Hse, Loita St.,
Mobile: (+254) 722 743 223 . # 10286, 00100 NAIROBI
----------------------------------+-----------------------------------------
What the hell, go ahead and put all your eggs in one basket.
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Pride goes before destruction,
a haughty spirit before a fall.
Proverbs 16:18
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
