Correct. I've often pined for a "list" grouping function....which would have helped you in this situation. SOmething like:
select emp_id, list(location_id) as location_ids from table where whatever grouped by emp_id Then the output would be: Emp ID Location_ids 1 locationA, locationB, etc.... Seems like a simple enough grouping algorithm...but as far as i know, this doesn't exist. After all, when grouping, you can add the columns, or subtract the columns, etc...why can't you concatenate their values? Which is really just the + overload for strings... Anyway, i'm venting now.... On 9/12/06, Rick Root <[EMAIL PROTECTED]> wrote: > > G Money wrote: > > How so? > > > > I still don't think he's going to get the values in a list form in a > single > > column using just SQL. > > > > On 9/12/06, Andrew Scott <[EMAIL PROTECTED]> wrote: > > > >>left outer join would have worked better > > left outer join would not have worked at all. Try it. > > simple joins (outer, inner, etc) would return multiple rows of data for > each individual person. It would *NOT* combine the multiple locations > into a single field. > > Rick > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Community/message.cfm/messageid:215208 Subscription: http://www.houseoffusion.com/groups/CF-Community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
