On Wed, Aug 6, 2008 at 5:18 AM, Morten Primdahl <[EMAIL PROTECTED]> wrote: > I've tried to find out if joins are preferred over subselects, but am not > able to come to a definite conclusion. I read that correlated subselects are > bad, and I should go for the join, but I know the id of the record in the > outer query and can hard code that into the subselect (if that makes a > difference). >
Sub queries should be avoided if possible in MySQL. -- Rob Wultsch [EMAIL PROTECTED] wultsch (aim) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
