> Short answer is mysql does not do sub-selects (i.e., a select inside of a > select). The join part is not this issue.
Wouldn't this depend on the version... I thought the newest versions, 4.x+, supported sub-selects. Ryan __________________________________ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]