A little help with a query please

From: DeanL <deanpmlonghurst_at_yahoo.com>
Date: Wed, 25 Jun 2008 19:36:11 -0700 (PDT)
Message-ID: <2c5ef12f-3970-4c26-8383-d90bfe2da32c@d19g2000prm.googlegroups.com>

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

Original text of this message