What is the name of the product with the color description 'yellow'?
create table ref_colors (color_code varchar, color_description varchar, PRIMARY KEY (color_code)); create table products (product_name varchar, color_code varchar, PRIMARY KEY (product_name))
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'