CREATE TABLE products (product_name VARCHAR2, product_description VARCHAR2, color_code VARCHAR2)
CREATE TABLE Ref_colors (color_description VARCHAR2, color_code VARCHAR2)

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" "T1" JOIN "Ref_colors" "T2" ON "T1"."color_code" = "T2"."color_code" WHERE "Herbs" = "product_category_code"