CREATE TABLE products (product_name VARCHAR, color_code VARCHAR)
CREATE TABLE ref_colors (color_code VARCHAR, color_description VARCHAR)

List all the product names with the 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 = "white"
SELECT "t1"."product_name" FROM "products" AS "t1" JOIN "ref_colors" AS "t2" ON "t1"."color_code" = "t2"."color_code" AND "t2"."color_description" = "white"