Merge Multiple Rows Into Single Result
From: Niko <nick_wakefield_at_hotmail.com>
Date: 14 Nov 2002 08:35:37 -0800
Message-ID: <9da94cd1.0211140835.56fa096b_at_posting.google.com>
Date: 14 Nov 2002 08:35:37 -0800
Message-ID: <9da94cd1.0211140835.56fa096b_at_posting.google.com>
Hi,
Does anyone know a way to do the following, given a table like
Field_A, Field_B
then runa group by query on it to merge the contents of field_b
seperating with commas.
select field_a, merge(field_b,',')
a first word
a second word
a third word
from table
group by a
resulting in
Field_A New_String
a first word, second word, thrid word
Received on Thu Nov 14 2002 - 17:35:37 CET