Problem with sorting results over two different columns

Question

Hello,

I have two MySQL tables, one with categories and one with products. For the first one, I also have a column which describes the category order. What I want to do is get all the products and sort them by category (which needs to be sorted ascending according to the 'order' field) and by price (also ascending).

The tables are:

categories
-id, (int)
- name, (text)
- order (int) 

products
- id, (int)
- model, (text)
- price, (float)
- category_id (int)

Answer 1

Select id, model, price
from products p , categories c
where c.id = p.category_Id
order by c.order, p.price