Combine two rows data where some empty fields (get those from parent)

Databases
1

I want to retrieve data from one row and where the fields are empty get the data from another row (with the same product_id). So here I want to get the data from row 3 but for all the fields that are empty get those from row 1:

product_id, v_id, name, summary, price
1, “1”, “beans”, “delicious and tasty”, “10.00”
1, “2”, “”, “”, “11.00”
1, “3”, “fava beans”, “”, “12.00”
1, “4”, “”, “”, “13.00”

select * from product where product_id=‘1’ and v_id=‘3’ (then if field=‘’ get from v_id=‘1’)

I hope that makes sense, thank you in advance.

2 
SELECT v3.product_id
     , [COLOR="Blue"]COALESCE(v3.name,v1.name) AS name
     , COALESCE(v3.summary,v1.summary) AS summary
     , COALESCE(v3.price,v1.price) AS price[/COLOR]
  FROM product AS v3
LEFT OUTER
  JOIN product AS v1
    ON v1.product_id = v3.product_id
   AND v1.v_id = 1        -- note no quotes
 WHERE v3.product_id = 1  -- note no quotes
   AND v3.v_id = 3        -- note no quotes