I don't think so unfortunately. He says in his first mail:
> I'm using an excel library that accepts a SELECT as input and generates an XLS file
> with the records as output.
So, probably csv is not going to help him, which is a shame :)
Walter
OlinData: Professional services for MySQL
Support * Consulting * Administration
http://www.olindata.com
On Tue, Jan 27, 2009 at 10:20 AM, Claudio Nanni <claudio.nanni@stripped> wrote:
> I think what you are looking for is something like this:
>
> ---------------------------------------------------------------------
>
> SELECT
>
> CONCAT(A.FIELD1,',',GROUP_CONCAT(B.FIELD2))
>
> FROM
>
> TABLE1 A LEFT JOIN TABLE2 B
>
> ON A.ID=B.ID_TABLE1
>
> ---------------------------------------------------------------------
>
> Cheers
>
> Claudio
