可以使用group by和聚合函数min()和max()来完成：

select p.id, p.name, min(value) as price_min, max(value) as price_max
from products p
inner join products_prices pr on pr.product_id = p.id
group by p.id, p.name

如果你想列出还没有价格的产品，你可以使用left join：

select p.id, p.name, min(value) as price_min, max(value) as price_max
from products p
left join products_prices pr on pr.product_id = p.id
group by p.id, p.name