Hi,
How can I order results depending on 2 fields in 1 query using "ORDER BY" in MySQL?
For example, I have the table Product, It contains the Mark and the Name fields.
I need to order Alphabetically the product Mark (Each Mark contains more than 1 product Name),
then within the product Mark I need to order by the product Name.
Of course it is wrong to use such query:
Select from Product Order by Name (select from Product Order by Mark);
Because MySQL doesn't support nested queries.
Thx.
