CREATE TABLE ref_product_categories (unit_of_measure VARCHAR2, product_category_code VARCHAR2)
CREATE TABLE products (product_category_code VARCHAR2, product_name VARCHAR2)

Find the unit of measurement and product category code of product named 'chervil'.
SELECT t2.unit_of_measure, t2.product_category_code FROM products AS t1 JOIN ref_product_categories AS t2 ON t1.product_category_code = t2.product_category_code WHERE t1.product_name = "chervil"
SELECT "t2"."unit_of_measure", "t2"."product_category_code" FROM "products" "t1" JOIN "ref_product_categories" "t2" ON "t1"."product_category_code" = "t2"."product_category_code" WHERE "chervil" = "t1"."product_name"