On 9 Jan 2004 at 16:48, Odhiambo Washington wrote: > * 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)'"
Hi Wash I can't see what is throwing the syntax error..p'raps I am just being dense. Try this query and see if it still throws the same error: SELECT popbox.local_part, popbox.password_hash, popbox.domain_name, CONCAT(domain.path,'/',popbox.mbox_name) AS path FROM popbox, domain WHERE popbox.domain_name = domain.domain_name Regards Rory McKinley Nebula Solutions +27 82 857 2391 [EMAIL PROTECTED] "There are 10 kinds of people in this world, those who understand binary and those who don't" (Unknown)
