On Mon, Oct 20, 2008 at 9:31 PM, Rob Wultsch <[EMAIL PROTECTED]> wrote:
> On Mon, Oct 20, 2008 at 8:30 PM, Perrin Harkins <[EMAIL PROTECTED]> wrote: > >> On Mon, Oct 20, 2008 at 10:15 PM, Sangeetha <[EMAIL PROTECTED]> wrote: >> > Gosh I wonder >> > why mysql does not support SEubqueries.. It just hangs in the copying to >> tmp >> > table status. Atleast I know whats wrong... Thanks very much >> >> It supports them, but won't optimize them well until 5.2. There's >> some good info here: >> >> http://www.xaprb.com/blog/2006/04/30/how-to-optimize-subqueries-and-joins-in-mysql/ >> >> - Perrin >> > > I'm pretty sure 5.2 became 6.0 > 6.0 is two major versions out > The last major release happened 3 years ago > What I should have said is: five two is six oh five one comes before six oh five oh three years old -- Rob Wultsch