Re: Can someone please explain this?

2004-10-07 Thread Peter Brawley
>From 5.0.1, I get ... e c b 1 1 1 2 2 2 3 3 3 NULLNULL4 PB - Original Message - From: Ian Sales To: [EMAIL PROTECTED] Sent: Thursday, October 07, 2004 4:21 AM Subject: Can someone please explain this? During s

Re: Can someone please explain this?

2004-10-07 Thread Ian Sales
Michael Stassen wrote: It's a bug: Depending on which bug report you look at, this result is either because mysql treats this as a nested join, or because mysql does not support nested joins. Frankly, I find t

Re: Can someone please explain this?

2004-10-07 Thread Michael Stassen
It's a bug: Depending on which bug report you look at, this result is either because mysql treats this as a nested join, or because mysql does not support nested joins. Frankly, I find the explanations make no

Can someone please explain this?

2004-10-07 Thread Ian Sales
During some training on SQL recently, the following occurred. No one can explain it. The training used five tables A, B, C , D and E, each with a single int column. Table A has column a with values 1, 2, 3, 4, 5 Table B has column b with values 1, 2, 3, 4 Table C has column c with values 1, 2,