RE: Stop query on first match

[Emmanuel van der Meulen]

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