* Rory McKinley [...] * Odhiambo Washington >> I have a query that executes well when run on MySQL-4.x, but not 3.23.x: [...] > I can't see what is throwing the syntax error..p'raps I am just > being dense.
"Note that INNER JOIN syntax allows a join_condition only from MySQL 3.23.17 on. The same is true for JOIN and CROSS JOIN only as of MySQL 4.0.11. " <URL: http://www.mysql.com/doc/en/JOIN.html > > 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 That should do it. :) -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]