Prev: Exists a aggregate function (Oracle9) for varchar that generate a comma separated lsit
Next: pl/sql forcing RHS of = in where clause to be variable?
From: DeanL on 25 Jun 2008 22:36
Hi Guys,

I need a little help putting a query together as I'm pulling my hair
out. I'm getting two values, one from each table. Table 1 has a
value and is in a 1 to many relationship with table 2 so what I'm
getting back is something like this:

Table1.Col1 Table2.Col1
A 1
A 2
A 3
B 2
B 6
B 8
B 9

What I'm trying to get the query to do is this:

Table1.Col1 Table2.Col1
A 1,2,3
B 2,6,8,9

Can anyone help me on this before I finally rip all my hair out.

Many thanks, Dean...
From: Krzysztof Jamróz on 26 Jun 2008 02:40
On Wed, 25 Jun 2008 19:36:11 -0700 (PDT), DeanL wrote:

> Table1.Col1 Table2.Col1
> A 1
> A 2
> A 3
> B 2
> B 6
> B 8
> B 9
>
> What I'm trying to get the query to do is this:
>
> Table1.Col1 Table2.Col1
> A 1,2,3
> B 2,6,8,9

Have you checked the thread "Exists a aggregate function..."? There are
given some methods you could use.

--
Krzysztof Jamr�z
 | 
Pages: 1
Prev: Exists a aggregate function (Oracle9) for varchar that generate a comma separated lsit
Next: pl/sql forcing RHS of = in where clause to be variable?