Speed up query

Databases
1

Hi!
I have tryed to rewrite this Query to make it faster but i cant get it working:
this is the line needed to be better:
$sqlproduct = “select * from product where product.id IN (select pro_id from product_data where visible=‘yes’ )”;

i have tryed this:
$sqlproduct = “SELECT product.*
FROM product LEFT JOIN product_data ON product.id=pro_id
WHERE pro_id = visible=‘yes’”;

and this:
SELECT DISTINCT product.* FROM product, product_data WHERE product.id=product_data.id;

but cant figure out how to make this:
(select pro_id from product_data where visible=‘yes’ ) in the Query

hope someone can help me

2 
SELECT product.*
  FROM product 
INNER
  JOIN product_data 
    ON product_data.pro_id = product.id
   AND product_data.visible = 'yes'