Returning "Outer Join" values in a single string

  • Thread starter Thread starter C Downey
  • Start date Start date
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Outer Joins??? 1
Outer Join 1
To give inner join and Left outer Join 3
don't understand outer join 3
Nesting outer joins with ODBC and Access 2003 3
Left outer join 10
Understanding Many-to-Many Relationship 4
How do I remove parent-child relationships in the parent table? 3

Back
Top