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 -- Rob Wultsch