testproduct_id | product_name | category_name ----------------+------------------------+---------------- 1 | Johns Fruit Cake | Confections 6 | Janes Favorite Cheese | Dairy Products 8 | Ellas Special Salmon | Seafood 9 | Roberts Rich Spaghetti | Grains/Cereals (4 rows)