ld1) as 'field-1'
from tmp
group by keyf;
-Original Message-
From: Javier [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 27, 2002 8:11 AM
To: [EMAIL PROTECTED]
Subject: Sum function question
Hi, I have a table like this
Key Field-1
A string1
A
Hi Javier,
> Hi, I have a table like this
>
>Key Field-1
>A string1
>A string2
>A string3
>B string1
>B string 2
>
> I want to create a query to get the following result (only one line by key
> field):
>
>A - string1,string2,string3
Hi, I have a table like this
Key Field-1
A string1
A string2
A string3
B string1
B string 2
I want to create a query to get the following result (only one line by key
field):
A - string1,string2,string3
B - string1,string2
I try to u
- Original Message -
From: Javier <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, February 20, 2002 2:47 PM
Subject: Sum function question
> Hi, i have a table like this
>
> Key Field-1
> A string1
> A string2
> A
Hi, i have a table like this
Key Field-1
A string1
A string2
A string3
B string1
B string 2
I want to create a query to get the following result (only one line by key
field):
A - string1,string2,string3
B - string1,string2
I try to use the Sum function but it
