On Monday, June 07, 2004 07:54, Jeff Smelser wrote; > On Monday 07 June 2004 12:49 am, Emmanuel van der Meulen wrote: > > I've looked in several books and searched Google but cannot get a way of > > doing this. It seems Oracle has a 'FIRST' in their select > which they use > > for such a use case. But I do not see anything for MySql anywhere. > > If your using a later mysql, you could use sub query with limit. > > Other then that, splitting the query is the only think off hand.
Thank you for you note and valuable feedback. Unfortunately I'm planning to go live before MySql 4.1 is production release so I need to find a work around. Do I understand your suggestion about splitting the query; I would first select all required rows from table a, then take each retrieved row from table and (in a loop in my java program) select from table b, using limit? Kind regards Emmanuel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
