what are the characteristics of the product name 'sesame'?
SELECT t2.characteristic_id FROM products AS t1 JOIN product_characteristics AS t2 ON t1.product_id   =   t2.product_id WHERE t1.product_name   =   "sesame"
characteristics of the product name 'sesame' refers to characteristic_id from product_characteristics table where the product_name is 'sesame'; join is used to connect products table with product_characteristics table based on product_id.