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 | Null | Key | Default | Extra |
+-------------+--------------+------+-----+---------+----------------+
| ID | int(4) | NO | PRI | NULL | auto_increment |
| Category | int(3) | YES | | NULL | |
| Item | varchar(20) | YES | UNI | NULL | |
| Description | varchar(255) | YES | | NULL | |
| UOM | varchar(20) | YES | | NULL | |
| Cost | float(7,2) | YES | | NULL | |
+-------------+--------------+------+-----+---------+----------------+
6 rows in set (0.00 sec)
mysql> describe categories;
+----------+-------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------+-------------+------+-----+---------+----------------+
| ID | int(3) | NO | PRI | NULL | auto_increment |
| Category | varchar(20) | YES | UNI | NULL | |
| Parent | varchar(20) | YES | | NULL | |
+----------+-------------+------+-----+---------+----------------+
What I'm trying to accomplish is to order the results such that after
stacking the data for all results for a certain category, that the next
results to be stacked should be those whose parent = the former category,
then move on to the next category, etc. How do I do this?
TIA,
Victor
