Re: Help to concatenate a result...

2005-11-22 Thread Cory @ SkyVantage
Thanks for the tip.. Here's the query that worked... SELECT GROUP_CONCAT(DISTINCT segfees SEPARATOR ',') from segfees WHERE ID_flights_segments=[insert value here] group by ID_flights_segments; inferno wrote: >Hi, > >You can use select group_concat(segfees) from fsf; >The information bellow is f

Re: Help to concatenate a result...

2005-11-22 Thread inferno
Hi, You can use select group_concat(segfees) from fsf; The information bellow is from mysql manual, but you have to have mysql 4.1.x => * |GROUP_CONCAT(/|expr|/)| This function returns a string result with the concatenated non-|NULL| values from a group. It returns |N