what is the product characteristic value for product name 'sesame'
SELECT t2.product_characteristic_value FROM products AS t1 JOIN product_characteristics AS t2 ON t1.product_id   =   t2.product_id WHERE t1.product_name   =   "sesame"
product characteristic value = product_characteristic_value; product name 'sesame' refers to WHERE condition on product_name = 'sesame'; joining tables products and product_characteristics on product_id;