On Thu, Jan 31, 2002 at 05:16:23PM +0100, [EMAIL PROTECTED] wrote:
> Your message cannot be posted because it appears to be either spam or
> simply off topic to our filter. To bypass the filter you must include
> one of the following words in your message:
>
> sql,query
>
> If you just reply to this message, and include the entire text of it in the
> reply, your reply will go through. However, you should
> first review the text of the message to make sure it has something to do
> with MySQL. Just typing the word MySQL once will be sufficient, for example.
>
> You have written the following:
>
> Thanks for the quick response.
>
> > > select t1.*, t2.name from t1, t2 where t2.id=t2_id;
> >
> > The above is actually expected behaviour, as you are not doing a join
> > at all, but a full Cartesian product.
>
> That t2_id is actually from t1. Sorry for the confusing naming. Here
> is a more verbose, but identical statement:
>
> select t1.*, t2.name from t1, t2 where t2.id=t1.t2_id;
>
> Since there is a join condition that works across both tables is this
> still considered a cartesian product? I did a quick sanity check and
> the number of rows returned from the problem statement equals the number
> of rows in t1, rather than t1*t2. Even if it was, I don't see why
> there is indeterminism in the return values for columns in the result of
> a cartesian product.
>
> Thanks,
>
> John
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
