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
smime.p7s
Description: S/MIME cryptographic signature
