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.na...@gmail.com> 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
