r
>
> > -
> >
> > -Original Message-
> > >From: Victor Subervi
> > >Sent: Aug 24, 2010 1:14 PM
> > >To: mysql@lists.mysql.com
> > >Subject: Complex Select Query
> > >
> > >Hi;
> > >I have the
ice.
TIA.
Victor
> -
>
> -Original Message-
> >From: Victor Subervi
> >Sent: Aug 24, 2010 1:14 PM
> >To: mysql@lists.mysql.com
> >Subject: Complex Select Query
> >
> >Hi;
> >I have the following query:
> >
> >select * from spr
It's a tree. See
http://www.artfulsoftware.com/mysqlbook/sampler/mysqled1ch20.html and
http://www.artfulsoftware.com/infotree/treequeryperformance.pdf.
PB
-
-Original Message-
>From: Victor Subervi
>Sent: Aug 24, 2010 1:14 PM
>To: mysql@lists.mysql.com
>Subject: C
Hi;
I have the following query:
select * from spreadsheets s join products p on p.Item=s.Item join
categories c on p.Category=c.ID where s.Client=%s order by p.category,
c.parent;
mysql> describe products;
+-+--+--+-+-++
| Field | Type
