Yes please.
select product_name,color_code,product_id from products
I want to know the the product names and their color descriptions.
select t1.product_name, t2.color_description from products as t1 join ref_colors as t2 on t1.color_code = t2.color_code
Hmm, can you tell me the color description of the product with the name “catnip”?
select t2.color_description from products as t1 join ref_colors as t2 on t1.color_code = t2.color_code where t1.product_name = "catnip"