SELECT T1.product_name ,  T2.color_description ,  T1.product_description FROM products AS T1 JOIN Ref_colors AS T2 ON T1.color_code  =  T2.color_code WHERE product_category_code  =  "Herbs"
List the names, color descriptions and product descriptions of products with category "Herbs".
SELECT T1.product_name , T2.color_description , T1.product_description FROM products AS T1 JOIN Ref_colors AS T2 ON T1.color_code = T2.color_code WHERE product_category_code = `` Herbs ''
select t1 . product_name , t2 . color_description , t1 . product_description from products as t1 join ref_colors as t2 on t1 . color_code = t2 . color_code where product_category_code = value
List the names , color descriptions and product descriptions of products with category `` Herbs '' .