The link below essentially means subquery support is useless for many traditional purposes. You are stuck in a correlated subquery thus performance is the query being run out-to-in (subquery run for every row?) instead of in-to-out as desired. Does anyone know of a work around for this? Apparantly the MySQL team refuses to even recognize this as a bug.
http://bugs.mysql.com/bug.php?id=9090 James Nobis Web Developer Academic Superstore 223 W. Anderson Ln. Suite A110, Austin, TX 78752 Voice: (512) 450-1199 x453 Fax: (512) 450-0263 http://www.academicsuperstore.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]