export products with all specific price

[Pere-e]

 

HI,

I want to export all the specific prices assigned to the products. 

SQL query: product name, product reference and the specific specifications it has.

I have the query:

SELECT * FROM ps_specific_price

But I don't relate it to the product table.

 

Can someone tell me how to do it?

 

thanks.