sub query returns multiple values (and i want it to)

[NorthStarDA]

I have no sql to show really, just a general question. One column in my query is derived from a sub query

SELECT .., (SELECT..) as col FROM etc..

The subselect might return 3 records (which will throw an error), but what i want it to do is return 1 row with the 3 values it brought back separated by commas or something- is this possible?

=========================================
Don't sweat the petty things and don't pet the sweaty things.

 

[guelphdad]

most likely GROUP_CONCAT is what you are looking for, but if it isn't can you be less abstract in what you are trying to do? an example perhaps to make clear what you want?