SELECT T1.product_name FROM products AS T1 JOIN ref_colors AS T2 ON T1.color_code  =  T2.color_code WHERE T2.color_description  =  'yellow'
Give the name of the products that have a color description 'yellow'.
SELECT T1.product_name FROM products AS T1 JOIN ref_colors AS T2 ON T1.color_code = T2.color_code WHERE T2.color_description = 'yellow '
select t1 . product_name from products as t1 join ref_colors as t2 on t1 . color_code = t2 . color_code where t2 . color_description = value
Give the name of the products that have a color description 'yellow ' .