从MySQL中的多个表中对产品数据进行排序

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

Mysql join with order by reference guide

Sample Query:

 select t1.[id],t1.[name],t2.[price]
 from [yourtable1] t1
 Join [yourtable2] t2 on
 t1.[id]=t2.[product_id]
 Order by t2.[price] Asc;

You can try this code...

 SELECT product_tbl.name, product_tbl.id, product_price.product_id, product_price.price FROM product_tbl, product_price WHERE product_tbl.id=product_price.product_id ORDER BY product_price.price DESC;