* 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]