A little help with a query please -
06-25-2008
, 09:36 PM
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... |