Re: [GENERAL] SQL query - single text value from group by

On Wed, 2004-09-08 at 17:13 +0100, Richard Huxton wrote: > mike wrote: > > Hi > > > > I am trying to work out if this is possible in a select query > > > > I have a group by query which could result in several rows, what I want > > to do is do a text equivalent of a sum() eg: > > > > SELECT sum(

Re: [GENERAL] SQL query - single text value from group by

mike wrote: Hi I am trying to work out if this is possible in a select query I have a group by query which could result in several rows, what I want to do is do a text equivalent of a sum() eg: SELECT sum(inv_id),date,cust from invoice group by date,cust Is there any way to get to a single concat

[GENERAL] SQL query - single text value from group by

Hi I am trying to work out if this is possible in a select query I have a group by query which could result in several rows, what I want to do is do a text equivalent of a sum() eg: SELECT sum(inv_id),date,cust from invoice group by date,cust Is there any way to get to a single concatenated in