SELECT t1.product_name FROM products AS t1 JOIN ref_colors AS t2 ON t1.color_code  =  t2.color_code WHERE t2.color_description  =  "white"
What are the names of products with 'white' as their color description?
SELECT t1.product_name FROM products AS t1 JOIN ref_colors AS t2 ON t1.color_code = t2.color_code WHERE t2.color_description = `` white ''
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
What are the names of products with 'white ' as their color description ?