Hello Victor, > What version of MySQL are you using? Have you > checked the cardinality on > these tables?
Problem solved! Optimizing the table brought the query time down to 17 secs.... Wow! Thanks for the input Victor and merci to Arnaud for the quick fix. Patrick __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]