It can be done but it involves quite a few statements
and the use of temporary variables and a temporary table.
assuming that your table is defined as follows
CREATE TABLE `tble` (
`keyf` char(1) default NULL,
`Field1` char(8) default NULL
)
do this:
set @k='';
set @field='';
create temp
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