Returning "Outer Join" values in a single string

C

C Downey

I have a one to many relationship on two tables. Table A is the parent,
Table B is the child. I want to write a SQL statement that will give me back
a single record for each item in A and a column which has the values from
Table B concatated in a single string...is this possible?

TIA
 
D

Dirk Goldgar

C Downey said:
I have a one to many relationship on two tables. Table A is the
parent, Table B is the child. I want to write a SQL statement that
will give me back a single record for each item in A and a column
which has the values from Table B concatated in a single string...is
this possible?
Click to expand...

In your query, invoke the fConcatChild() function described and defined
here on the Access Web:

http://www.mvps.org/access/modules/mdl0004.htm
 
Top