@lists.mysql.com
Subject: Complex Select Query
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
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
://www.artfulsoftware.com/mysqlbook/sampler/mysqled1ch20.html and
http://www.artfulsoftware.com/infotree/treequeryperformance.pdf.
PB
-
-Original Message-
From: Victor Subervi victorsube...@gmail.com
Sent: Aug 24, 2010 1:14 PM
To: mysql@lists.mysql.com
Subject: Complex Select Query
: Victor Subervi victorsube...@gmail.com
Sent: Aug 24, 2010 1:14 PM
To: mysql@lists.mysql.com
Subject: Complex Select Query
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