php - Sort product data from multiple tables in MySQL

Question

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)

Answer 1

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

Mysql join with order by reference guide