On Wed, 23 Apr 2008 07:18:44 +0200
"A. Kretschmer" <[EMAIL PROTECTED]> wrote:
> am Tue, dem 22.04.2008, um 22:25:04 +0100 mailte Tarlika Elisabeth
> Schmitz folgendes:
> > TABLE product: product_pk, product_name, department_fk
> > TABLE product: department_pk, department_name
> >
> > ...
> >
On Wed, 23 Apr 2008 09:13:03 -0400
Alvaro Herrera <[EMAIL PROTECTED]> wrote:
> Tarlika Elisabeth Schmitz wrote:
>
> > 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 cru
Tarlika Elisabeth Schmitz wrote:
> 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
am Tue, dem 22.04.2008, um 22:25:04 +0100 mailte Tarlika Elisabeth Schmitz
folgendes:
> 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
>
> e
