mysql将多个表的数据排序,从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