Has anyone found a problem (and solution) on LEFT JOIN when using MySQL version 3.23.38 under SuSE Linux? We have two tables of 5000 and 1000 records respectively but LEFT JOIN takes over 10 minutes. Can anyone give any guidance on this? Thanks Anthony Appleby --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php