James Raff wrote:
I have MYSQL 3.23.32 on a Cobalt 550 platform. I see from the FAQ's that sub
That's a *very* old version. The latest 3.23 is 3.23.58. The current production release is 4.0.20. You should consider upgrading.
queries will not work on MYSQL < 4.1. Is there a way to use JOIN statements instead or do these fail too.
Did you try? JOINs certainly do work in 3.23. The manual offers some suggestions <http://dev.mysql.com/doc/mysql/en/Rewriting_subqueries.html>.
eg: SELECT some_ID from someTable NOT IN (Select some_ID from ANOTHERTABLE)
SELECT some_ID FROM someTable s LEFT JOIN ANOTHERTABLE a ON s.some_ID = a.some_ID WHERE a.some_ID IS NULL;
Or do I have to redesign my website!
Any help appreciated
Michael
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]