>> 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 > I sit corrected, 4.1x but its alpha from the manual:
Subqueries are supported in MySQL version 4.1. I run a production IPP so we run debian with is very far BACK from the bleeding edge. William R. Mussatto, Senior Systems Engineer Ph. 909-920-9154 ext. 27 FAX. 909-608-7061 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]