Emmanuel van der Meulen wrote:
On Monday, June 07, 2004 19:09, Michael Stassen wrote;
This doesn't quite make sense. You seem to say that several rows
will match but then you say only one will. It must be one or the
other. Perhaps I've misunderstood you.
Firstly, Michael thank you for your assi
On Monday, June 07, 2004 20:23, Justin Swanhart wrote
>> It can only ever return one row from table b, for
>> each row on table a, due
>> to the contents that is stored in table b. The
>> table contains in excess of
>> a million records. What happens as a result of the
>I assume that you have m
Hello all,
Thank you to everyone who assisted me.
I'm wondering about my theory around the between as posted previously.
Can anyone provide further insights regarding that theory?
Kind regards
Emmanuel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscrib
On Monday, June 07, 2004 19:09, Michael Stassen wrote;
> This doesn't quite make sense. You seem to say that several rows
> will match
> but then you say only one will. It must be one or the other.
> Perhaps I've
> misunderstood you.
Firstly, Micheal thank you for your assistance; I'll elaborat
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
This doesn't quite make sense. You seem to say that several rows will match
but then you say only one will. It must be one or the other. Perhaps I've
misunderstood you. You also seem to imply that with BETWEEN you get a full
table scan even though there is only one match for each row. That
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
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