A little help with a query please

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... Received on Wed Jun 25 2008 - 21:36:11 CDT