I am not quite sure whether this would be sensible or indeed at all possible to do in SQL:
TABLE product: product_pk, product_name, department_fk TABLE product: department_pk, department_name example data: SELECT product_pk, department_name, product_name ... LEFT JOIN ...: 1, "cakes & desserts", "apple crumble" 2, "cakes & desserts", "cheese cake" 3, "starters & soups", "french onion soup" I need to extract the words from department_name and product_name (words are separated by spaces) and get something like: 1 cakes 1 desserts 1 apple 1 crumble 2 cakes 2 desserts 2 cheese 2 cake 3 starters 3 soups 3 french 3 onion 3 soup Would it be more sensible to produce a table join and split the result into keywords programmatically? -- Best Regards, Tarlika Elisabeth Schmitz A: Because it breaks the logical sequence of discussion Q: Why is top posting bad? -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
