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... > > > > -Wash > > > -- > +================================================================== ====+ > |\ _,,,---,,_ | Odhiambo Washington <[EMAIL PROTECTED]> > Zzz /,`.-'`' -. ;-;;,_ | Wananchi Online Ltd. www.wananchi.com > |,4- ) )-,_. ,\ ( `'-'| Tel: +254 20 313985-9 +254 20 313922 > '---''(_/--' `-'\_) | GSM: +254 722 743223 +254 733 744121 > +================================================================== ====+ > "Whatever the missing mass of the universe is, I hope it's not > cockroaches!" > -- Mom >
Hi Wash Can you post the error message? 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) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]