SELECT * FROM表中，替换FK的名称

Question

我有2个表，产品有主键和名称，价格有pk，fk(pk of product)和价格。现在我必须select * from price，但需要显示产品名称而不是fk。我怎样才能做到这一点？

Answer 1

SELECT pd.name, pc.price 
    FROM product AS pd 
     INNER JOIN price AS pc 
      ON pd.id = pc.productid 

Answer 2

，你可以这样做的：

Select p.*, pr.Name from price as p 
join product as pr on p.productid = pr.Id