Humph... >The only good news I have about this is that it is on the list of >things that ought to be included at some point: > >http://www.mysql.com/doc/en/TODO_future.html Subselect have been on the TODO list for over five years... I wouldn't go holding your breath. .r