SELECT * FROM table, replace FK with your name

Question

I have 2 tables, the product has a primary key and name, the price has pk, a fk(pk of product)and the price. Now I have to select * from price, but you need to show the product name instead of fk. How can i do this?

Answer 1

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

Answer 2

you can do it like this:

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