I have two tables. The first:
Products table:
+----+-----------+
| id | name |
+----+-----------+
| 1 | Product 1 |
| 2 | Product 2 |
| 3 | Product 3 |
+----+-----------+
This contains product names and other table contains prices for different product variants:
Products prices table:
+-----+------------+-------------+
| id | product_id | price |
+-----+------------+-------------+
| 5 | 1 | 12.00 |
| 6 | 1 | 32.00 |
| 11 | 1 | 56.00 |
| 14 | 2 | 11 |
| 44 | 3 | 12 |
+-----+------------+-------------+
I need to create a sort on price (lowest and highest)
解决方案
Yes you can, for this you have to use JOIN and ORDER BY clause.
Ex:
select t1.id, t2.product_id t2.price FROM table1 t1 JOIN table2 t2 ON t1.id = t2.pid ORDER BY t2.price